What is HAVING?

Filter groups with HAVING.

What is HAVING?

HAVING filters groups. WHERE filters rows, HAVING filters groups.

SELECT category, COUNT(*)
FROM products
GROUP BY category
HAVING COUNT(*) > 5;

This query returns categories with more than 5 products.

category, COUNT(*) is selected from products. Rows are grouped by category; aggregate functions are computed per group. HAVING COUNT(*) > 5 runs after grouping and drops groups that fail the condition.

What is HAVING? — details

HAVING runs after aggregation. WHERE is applied before GROUP BY, HAVING after.

For example, HAVING COUNT(*) > 5 keeps only categories with more than 5 products; you can't put this in WHERE because the count hasn't been computed yet.

Exercise What is HAVING?

Find categories with more than 5 products using HAVING COUNT(*) > 5.

Show example solution

SELECT category, COUNT(*)
FROM products
GROUP BY category
HAVING COUNT(*) > 5;

Test yourself

What does HAVING filter?
- Groups
- Rows
- Columns
- Tables
Show answer

Groups — HAVING filters groups.

Add HAVING

SELECT category, COUNT(*)
FROM products
GROUP BY category
____ COUNT(*) > 5;

Show answer

SELECT category, COUNT(*)
FROM products
GROUP BY category
HAVING COUNT(*) > 5;

What is HAVING: match the terms

HAVING

group filter
WHERE

row filter
GROUP BY

group
COUNT

count

Next lesson: HAVING vs WHERE

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies