Tuesday, November 11, 2008

When do you use WHERE clause and when do you use HAVING clause?

When do you use WHERE clause and when do you use HAVING clause? 

HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

No comments:

Post a Comment

Thanks to given comments.......

My Blog List