CWS Technology

Ever been asked in an SQL interview — “What’s the difference between WHERE and HAVING?”

Here’s the clear breakdown recruiters love to hear

✅ WHERE filters data before aggregation — it’s for individual rows.

✅ HAVING filters after aggregation — it’s for grouped results.

✅ Use WHERE for raw conditions (e.g., salary > 50000)

✅ Use HAVING for aggregated conditions (e.g., AVG(salary) > 60000)

Remember the SQL query ex*****on order:

FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY

Mastering this logic helps you explain not just what you know — but why it works.