sql - 如何在 MySQL 中按 SUM() 进行排序？

Question

我有一个表:“ID name c_counts f_counts”

我想通过 sum(c_counts+f_counts) 对所有记录进行排序但这不起作用:

SELECT * FROM 表 ORDER BY sum(c_counts+f_counts) LIMIT 20;

Answer 1

不要忘记，如果您混合分组(即 SUM)字段和非分组字段，则需要按非分组字段之一进行 GROUP BY。

试试这个:

SELECT SUM(something) AS fieldname
FROM tablename
ORDER BY fieldname

或者这个:

SELECT Field1, SUM(something) AS Field2
FROM tablename
GROUP BY Field1
ORDER BY Field2

您始终可以执行如下派生查询:

SELECT
   f1, f2
FROM
    (
        SELECT SUM(x+y) as f1, foo as F2
        FROM tablename 
        GROUP BY f2
    ) as table1
ORDER BY 
    f1

很多可能性!