Wednesday, 28 October 2015

Difference between Where and Having clause?

WHERE
HAVING
Where can be used other then select statement also.
Having is used only with the select statement.
Where applies to each and every single row.
Having applies to summarized rows (with using Group By).
In where clause the data that fetched from memory according to condition.
In having, The completed data firstly fetched and then separated according to condition.
Where is use before group by.
Having is used to impose condition on group by function and use.

No comments:

Post a Comment