HAVING

Applies to: sql

HAVING filters groups after aggregation. WHERE filters rows before aggregation.

SELECT plan, COUNT(*)
FROM users
GROUP BY plan
HAVING COUNT(*) > 10;

See also: group-by, where, aggregate-function