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