Mysql Count() as Total WHERE Total? [英] Mysql Count() as Total WHERE Total?

查看：59 发布时间：2021/6/5 19:51:55 sql mysql

本文介绍了Mysql Count(*) as Total WHERE Total?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

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

不起作用:(

我认为您想过滤组.使用 HAVING COUNT(*) 而不是 WHERE:

I think you wanted to filter groups. Use HAVING COUNT(*) instead of WHERE:

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

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

If you what to sort groups by number of elements then use ORDER BY:

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

这篇关于Mysql Count(*) as Total WHERE Total?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文

Mysql Count(*) as Total WHERE Total? [英] Mysql Count(*) as Total WHERE Total?