Compare WHERE and HAVING clauses. WHERE filters rows before grouping; HAVING filters groups after GROUP BY.
Skip to solutionKEEP THE
easyDSA
What is the difference between WHERE and HAVING?
1.0k views
01
Understand the problem
wherehaving
02
Attempt it yourself
Sketch your approach before reading the solution — that's what interviews test.
Nudge consolestandby
Stuck? Beam a request up — the console returns a conceptual nudge that guides your logic without spoiling the implementation.
03
Study the solution
WHERE filters individual rows before grouping; HAVING filters groups after GROUP BY and can use aggregate functions (e.g. HAVING COUNT(*) > 5). You can't use aggregates in WHERE.
Solution ready — 2 min read
Classified // press E to declassify
04
Run the code
SQLWHERE vs HAVING Playground
05
Join the discussion
Discussion (0)
Sign in to join the discussion.
No responses yet. Be the first to share what you think.
Transmission complete // awaiting log
KEEP THE
STREAK ALIVE.
Dossier 6 of 70 decoded in the SQL track. One more won't hurt.