Lesson 2.3 · Pro
WHERE vs HAVING
Filter rows before grouping with WHERE, and filter groups after grouping with HAVING.
In this lesson
- WHERE filters rows before grouping
- HAVING filters groups after grouping
- Use both together
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.