HAVING¶

HAVING 子句用于与 GROUP BY 一起进行过滤。HAVING 在生成组之后应用过滤器，而 WHERE 在生成任何组之前应用过滤器：

SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
HAVING condition

例如：

SELECT MAX(A) FROM table1 GROUP BY B HAVING C < 0

HAVING 语句也通过在 GROUP BY 中使用的别名引用列：

SELECT MAX(A), B - 1 as val FROM table1 GROUP BY val HAVING val 5