I kept using WHERE when I should have been using HAVING

📰 Medium · Data Science

Learn when to use WHERE and HAVING in SQL queries to filter data before and after grouping

beginner Published 16 Apr 2026

Action Steps

Use WHERE to filter rows before grouping data
Use HAVING to filter grouped results after applying aggregate functions like COUNT, SUM, and AVG
Apply GROUP BY to package data into groups of rows that share the same value
Practice using SELECT DISTINCT and GROUP BY to understand the difference between them
Test your understanding by writing SQL queries that use WHERE and HAVING correctly

Who Needs to Know This

Data analysts and scientists who work with SQL databases can benefit from understanding the difference between WHERE and HAVING to improve their data filtering skills

Key Insight

💡 WHERE filters rows before grouping, while HAVING filters the grouped results after