PostgreSQL HAVING
HAVING 过滤分组结果,作用于聚合之后的行集。
Key PointsPostgreSQL,HAVING,分组过滤
讲解
HAVING 过滤分组结果,作用于聚合之后的行集。
示例
SQL
SELECT age, count(*) FROM company GROUP BY age HAVING count(*) > 1;讲解
HAVING 过滤分组结果,作用于聚合之后的行集。
示例
SQL
SELECT age, count(*) FROM company GROUP BY age HAVING count(*) > 1;