What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ?

 Posted by Chikul on 12/21/2009 | Category: Sql Server Interview questions | Views: 1990
Answer:

Both Clause are used to check the Condition at the time of Retrival of records in Database.
WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.
Having Clause is basically used only with the GROUP BY function in a query.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response