Difference between where and having clause in select statment ?

 Posted by Rajkatie on 5/20/2012 | Category: Sql Server Interview questions | Views: 2694 | Points: 40
Answer:

The where clause specifies the criteria which individual record s must meet for the query. It can used along select,delete and update statement.

The having clause specifies the criteria which individual group or an aggregate function must meet for the query. It can only used with select statement.


Source: Pluralsight | Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response