HAVING CLAUSE

- HAVING CLAUSE is used only with the SELECT statement.

- It is generally used in a GROUP BY clause in a query.

- If GROUP BY is not used, HAVING works like a WHERE clause.

WHERE Clause

- It is applied to each row before they become a part of the GROUP BY function in a query.