MS SQL 2008 或者以上
; with tbl as
(
Select id, sum(score) as sumsc Form tb1 group by id
)
select * from tbl order by sumscMYSQL
Select id, sum(score) as sumsc Form tb1 group by id order by sumsc ?? 没测试
; with tbl as
(
Select id, sum(score) as sumsc Form tb1 group by id
)
select * from tbl order by sumscMYSQL
Select id, sum(score) as sumsc Form tb1 group by id order by sumsc ?? 没测试
select sum(sore) from 表名 group by id order by sum(sore) desc
bingo