大家帮个，这个合计查询该如何写呢，解决立刻揭贴

[Pdyu]

表如下：
USER NUM
A 1
B 1
A 2
B 1
B 1
B 7
C 8

查询结果如下
USER SUM
A 3
B 10
C 8

这个分类合计的SQL语句该如何写呢

[txlicenhe]

Select User,sum(num) as sum from 表 group by User

[txlicenhe]

Select User,sum(num) as sum from 表 group by User order by User

[ghost555]

select user, sum(num) as sum from yourtable group by user