Databases · Junior · Question 28 of 75

What is the difference between `WHERE` and `HAVING`?

1They are interchangeable
2HAVING is only for joins
✓Correct answer: WHERE filters rows before grouping; HAVING filters groups after aggregation

Explanation

Example: GROUP BY city HAVING COUNT(*) > 100. You can't use an aggregate in WHERE because aggregates don't exist yet at that stage.

Further reading

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.