SQL · Aggregation and grouping

having

Filters groups after aggregation, unlike WHERE which filters rows first.

sqlRunnable example sql course

Syntax

having aggregate_condition

Example

Open in the lab

WITH lessons(course, minutes) AS (VALUES ('HTML', 10), ('HTML', 20), ('CSS', 15))
SELECT course, sum(minutes) AS total FROM lessons GROUP BY course HAVING sum(minutes) > 20;

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

having

Example

More in this group

Learn this in the course