HAVING语法

SELECT group_by_column, AGG_FUNC(column_expression) AS aggregate_result_alias, …
FROM mytable
WHERE condition
GROUP BY column
HAVING group_condition;

更多推荐

自学SQL网:Lesson 11学习笔记