What is difference between where and having in SQL?

Question

Can anyone explain the difference between where and having in SQL?

Answer 1

The difference between Where and Having clauses can be better explained when used along with Group by. Where clause is used to filter the rows before grouping and Having is used to filter the rows after grouping. This is the main difference between the where and having clauses.

In Where clause, we cannot use aggregate functions (AVG, MAX, MIN, SUM, and COUNT) but we can use aggregate functions in Having clauses. We can use where clause in SELECT, UPDATE, and DELETE statements but Having can be used only with Group by clause.

Here is the syntax to use Where and Having clauses in the same query:

SELECT columns_list
FROM TableName
WHERE condition(s)
GROUP BY columns_list
HAVING condition
ORDER BY columns_list;

You can check out this SQL interview questions blog by Intellipaat for more FAQs in the SQL interview with a better explanation.