sql - Mysql Count(*) as Total WHERE 总计？

Question

SELECT
  Id, QId, UName, Ans, Date, COUNT(*) * 10 as Total
FROM
  question
WHERE
  COUNT(*)
DESC
GROUP BY
  UName

不起作用:(

Answer 1

我想你想过滤组。使用 HAVING COUNT(*) 而不是 WHERE:

SELECT Id, QId, UName, Ans, Date, Count(*) * 10 as Total
FROM question
GROUP BY UName
HAVING Count(*)

如果您想按元素数量对组进行排序，请使用 ORDER BY:

SELECT Id, QId, UName, Ans, Date, Count(*) * 10 as Total
FROM question
GROUP BY UName
ORDER BY Count(*) DESC