sql语句问题 sql数据库
表
列name number
a 1
a 1
b 1
b 2
c 3
c 1
我想把name相同的number累加在按着number从大到小排序应该怎么写

[解决办法]

SQL code

select * from(select name,sum(number) as number from tb group by name) aorder by number desc