Summary - HAVING

Find the top-selling category with GROUP BY and HAVING.

Summary - HAVING

HAVING filters groups. WHERE sets row-level, HAVING sets group-level conditions.

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

Summary HAVING query.

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.

Exercise Summary - HAVING

Summary: find categories with more than 5 products using HAVING.

Show example solution

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

Test yourself

Where does a group condition go?
- WHERE
- HAVING
- FROM
- SELECT
Show answer

HAVING — A group condition goes in HAVING.
Summary - HAVING: match the terms

HAVING

group filter
WHERE

row filter
AND

both
OR

at least one

Next lesson: COUNT

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies