Tuesday, 1 September 2015

Difference Between Where and Having

WHERE
HAVING
WHERE CLAUSE WILL BE USED TO FILTER THE DATA BEFORE THE GROUP BY CLAUSE.
HAVING CLAUSE WILL BE USED TO FILTER THE DATA AFTER THE GROUP BY CLAUSE.
WHERE CLAUSE WILL BE APPLIED ON DATA DIRECTLY.
HAVING CLAUSE WILL BE APPLIED ON AGGREGATED DATA i.e. SUM, MAX, MIN,..
APART FROM SELECT STATEMENT WE CAN USE THIS WHERE CLAUSE WITH UPDATE, DELETE.
APART FROM SELECT STATEMENT WE CAN NOT USE THIS WITH ANY COMMAND.

No comments:

Post a Comment