求sql语句，急

[youcailing]

表结构如下
xm money time
kkk 54 12:00
lll 76 1:00
xxx 65 8:00
kkk 34 6:00
www 43 6:00
rrr 100 5:00
求捐款总额前3名者，money为所捐的款，每个人可以捐多次

[CrazyFor]

select top 3 xm,sum(money) as money from 表 group by xm order by money

[Rewiah]

select top 3 xm,sum(money) as money from tablename group by xm order by sum(money) desc

or:
select top 3 xm from tablename group by xm order by sum(money) desc

[pengdali]

select top 3 xm,sum(money) money from 表 group by xm order by sum(money) desc

[SophiaWang]

select top 3 xm,sum(money) as SumMoney
from table_name
group by xm
order by SumMoney desc

[yoki]

select top 3 xm from tablename group by xm order by sum(money) desc

[youcailing]

谢谢大家，非常感谢，我要加分