Saturday, June 9, 2012

what are the differencces between where and having clause

where clause
To filter data before 'group by' use where clause.
To select particular groups use where clause.
If condition does not have aggregate functions use where clause.

Having Clause
To filter data after group by use having clause.
To select particular groups use having clause.
Used to apply functions on aggregate functions.

No comments:

Post a Comment