Differentiate Between A Having Clause And A Where Clause.

1.	Differentiate Between A Having Clause And A Where Clause.
Answer» 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. HAVING CLAUSE : WHERE Clause :

Answer»

HAVING CLAUSE :

WHERE Clause :

It is APPLIED to each ROW before they BECOME a part of the GROUP BY function in a query.

HAVING CLAUSE :

WHERE Clause :

Discussion