Saturday, February 09, 2013

What is the difference between Where and Having Clause?

Posted by Rahul Kharde at 12:15 PM

  
Where Clause
Having  Clause
WHERE clause can be used without GROUP BY clause.
HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause.
WHERE clause can not contain aggregate functions.
HAVING clause can contain aggregate
functions.
WHERE clause can operate individual
row.
HAVING clause can operate group
 of row.
It is more fast.
It is much slow.
WHERE clause select rows before
 grouping.
HAVING clause select rows after 
grouping


                                                    





If you enjoyed this post and wish to be informed whenever a new post is published, then make sure you subscribe to my regular Email Updates. Subscribe Now!


Kindly Bookmark and Share it:

YOUR ADSENSE CODE GOES HERE

0 comments:

Have any question? Feel Free To Post Below:

 

Popular Posts

Recent Comments

© 2011. All Rights Reserved | Help to understand .Net | Template by Blogger Widgets

Home | About | Top