oracle求和

[pingliu_]

表a
name num
a 100
a 101
a 102
b 103
b 104
b 105


结果：
表b
name num
a 303
b 312

[吉普赛的歌]

select sum(num) from a group by [name]

[吉普赛的歌]

select name,sum(num) as num from a group by name