SQL HAVING
HAVING 对分组后的结果做过滤（WHERE 不能接聚合函数），通常紧跟 GROUP BY。
Key PointsSQL,HAVING,GROUP BY,分组过滤
讲解
HAVING 对分组后的结果做过滤（WHERE 不能接聚合函数），通常紧跟 GROUP BY。
示例
SQL
SELECT site_id, SUM(count) AS total
FROM access_log
GROUP BY site_id
HAVING SUM(count) > 50;Output
site_id total
------- -----
2 100
3 230讲解
HAVING 对分组后的结果做过滤（WHERE 不能接聚合函数），通常紧跟 GROUP BY。
示例
SQL
SELECT site_id, SUM(count) AS total
FROM access_log
GROUP BY site_id
HAVING SUM(count) > 50;Output
site_id total
------- -----
2 100
3 230