What is the difference between a HAVING CLAUSE and
a WHERE CLAUSE?
They specify a search condition for a group or an aggregate. But the
difference is that 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 a query whereas WHERE Clause is applied to each row before they are
part of the GROUP BY function in a query.
No comments :
Post a Comment