easyDSA

What is the difference between WHERE and HAVING?

Q: What is the difference between WHERE and HAVING?

## WHERE vs HAVING Both clauses filter result rows, but they run at different stages of logical query execution: - **`WHERE`** filters individual raw rows **before** they are grouped by `GROUP BY`. It cannot refer to aggregate functions (like `SUM` or `COUNT`). - **`HAVING`** filters summary group rows **after** they are grouped by `GROUP BY`. It is designed to filter on aggregate calculations. FROM WHERE <t

1.0k views

Understand the problem

Compare WHERE and HAVING clauses. WHERE filters rows before grouping; HAVING filters groups after GROUP BY.

wherehaving

Attempt it yourself

Sketch your approach before reading the solution — that's what interviews test.

Stuck? AI Nudge Available

Get a conceptual hint to guide your logic without spoiling the final implementation.

Study the solution

The solution is waiting

Give it an honest attempt first — then compare your thinking with the full walkthrough.

Run the code

SQLWHERE vs HAVING Playground

Join the discussion

Discussion (0)

No responses yet. Be the first to share what you think.

What is the CASE expression?

What are the different types of SQL joins?