HAVING vs WHERE

Learn the difference between HAVING and WHERE.

HAVING and WHERE

WHERE filters rows, HAVING filters groups. Both can appear in the same query.

SELECT category, SUM(price)
FROM products
WHERE price > 10
GROUP BY category
HAVING SUM(price) > 100;

This query returns categories whose sum of products over 10 exceeds 100.

category, SUM(price) is selected from products. WHERE keeps only the rows where price > 10 holds. Rows are grouped by category; aggregate functions are computed per group. HAVING SUM(price) > 100 runs after grouping and drops groups that fail the condition.

HAVING and WHERE — details

WHERE narrows rows before GROUP BY; HAVING filters groups after they are formed.

For example, WHERE price > 10 ignores cheap products, then HAVING SUM(price) > 100 picks categories with a high total.

Exercise HAVING and WHERE

Use WHERE to pick products over 10, then HAVING to keep category totals over 100.

Show example solution

SELECT category, SUM(price)
FROM products
WHERE price > 10
GROUP BY category
HAVING SUM(price) > 100;

Test yourself

Add WHERE

SELECT category, SUM(price)
FROM products
____ price > 10
GROUP BY category
HAVING SUM(price) > 100;

Show answer

SELECT category, SUM(price)
FROM products
WHERE price > 10
GROUP BY category
HAVING SUM(price) > 100;

When does WHERE run?
- After GROUP BY
- Before GROUP BY
- After HAVING
- Last
Show answer

Before GROUP BY — WHERE runs before GROUP BY.
HAVING vs WHERE: match the terms

WHERE

row
HAVING

group
GROUP BY

group by
SUM

sum

Next lesson: HAVING with aggregates

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies