Question

sql 中 order by sum 语句怎么用

Answer 1

--我举个例子你就懂了
CREATE TABLE ts
(
id INT,
VALUE INT
)
GO
INSERT ts
SELECT 1,2 UNION ALL
SELECT 1,3 UNION ALL
SELECT 1,2 UNION ALL
SELECT 2,4 UNION ALL
SELECT 2,21 UNION ALL
SELECT 3,2 UNION ALL
SELECT 3,2
GO
SELECT id ,sum(value) AS s_v
FROM ts
GROUP BY id
ORDER BY sum(VALUE)
/*
id s_v
---- ----
3 4
1 7
2 25*/

就是通过分组聚合后 对分组元素进行排序
本例中就是对ID分组 然后按照id对应的value总和进行排序

Answer 2

select * from table order by sum
意思是：返回表的所有行，行排序根据sum的降序来排

Answer 3

排序，依靠sum这一列