PostgreSQL HAVING

HAVING 过滤分组结果,作用于聚合之后的行集。

Beginner
Key PointsPostgreSQL,HAVING,分组过滤

讲解

HAVING 过滤分组结果,作用于聚合之后的行集。

示例

SQL
SELECT age, count(*) FROM company GROUP BY age HAVING count(*) > 1;

Friends & Partners