Sunday, 28 October 2012

Difference Between Where and Having clause in sql server 2008?


DIFFERENCE:
in 'where' clause every records filtered based on where
in 'having' is with aggregate records (group by functions )

http://blog.sqlauthority.com/2007/07/04/sql-server-definition-comparison-and-difference-between-having-and-where-clause/

No comments:

Post a Comment