What is the difference between WHERE and HAVING clauses?
Understanding WHERE vs HAVING Clauses in MySQL
In MySQL, both WHERE and HAVING clauses are used to filter data, but they operate at different stages of query processing.
Key Differences Between WHERE and HAVING
WHERE filters rows before any grouping occurs. It applies conditions directly to individual rows in the table.
HAVING filters groups after aggregation when using
GROUP BY. It applies conditions to the results of aggregate functions.WHERE cannot be used with aggregate functions like
SUM()orCOUNT()directly, whereas HAVING is designed to filter based on aggregates.Example:
- WHERE:
SELECT * FROM employees WHERE salary > 50000; - HAVING:
SELECT department_id, SUM(salary) AS total_salary FROM employees GROUP BY department_id HAVING total_salary > 200000;
- WHERE:
In summary, use WHERE to filter individual rows before grouping, and use HAVING to filter groups after aggregation.