求一汇总SQL语句

[duyerei]

例如表a:
ID 金额
1 100
2 50
3 100
1 200
2 30
3 20

现在想要每个ID的总金额如:
ID 金额
1 300
2 80
3 120
这个语句怎么实现?(实际的数据量比这个例子很大)

[点点星灯]

select id,sum(金额) from tablename
group by id

[greatqn]

用group by 哦。

[wym840713]

select sum(金额)
from table
group by id

[九斤半]

select ID,sum(金额) as 金额 group by ID