如何在同一个 SQL 中组合 HAVING 和 GROUP BY？

Question

我当前的查询如下：

SELECT user_id, sum(...) as total from mytable
group by user_id

哪个工作正常

但是当我尝试时

SELECT user_id, sum(...) as total from mytable
group by user_id
having total >= 10

出现错误

SELECT user_id, sum(...) as total from mytable
having total >= 10

工作正常。如何结合 HAVING 和 GROUP BY？

Answer 1

SELECT user_id, sum(...) as total from mytable
group by user_id
having SUM(...) >= 10

Answer 2

HAVING 与聚合函数一起使用，而不是与列一起使用。它类似于 where 子句，但用于聚合。