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