SQL Database Concepts Interview Question:

Explain Differentiate between a HAVING CLAUSE and a WHERE CLAUSE?

Submitted by: Administrator

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.
Submitted by: Administrator