Oris
Today
Universe
Explore
Studio
Authors
Account
Lesson 1 of 7
What is the key difference between WHERE and HAVING?
WHERE filters rows before grouping; HAVING filters groups after aggregation
HAVING filters rows and WHERE filters groups
They are interchangeable and behave identically
WHERE only works with GROUP BY; HAVING works without it
Check
Today
Universe
Explore
Profile