WHERE vs HAVING

Question

WHERE vs HAVING

Accepted Answer

The logical order in SQL is: FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER BY. WHERE runs before aggregation, so it cannot reference aggregate results like SUM() or COUNT(). HAVING runs after aggregation and is specifically designed to filter on aggregate values. Using WHERE where HAVING is needed, or vice versa, causes either a syntax error or incorrect results.