Differences between Where and Having

Differences between Where and Having

Specifies a search condition for a group or an aggregate. HAVING can be used only with the SELECT statement.

HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in aquery.

WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.