- WHERE clause can be used with - Select,Insert and Update statements, Where as HAVING Can be used only with select statement
- Where filters rows before aggregation(GROUPING),Where as,HAVING filter groups,after aggregations are performed.
- Aggregate functions cannot be used in WHERE Clause, unless it is in a subquery contained in HAVING Clause,Whereas,aggregate functions can be used in Having clause.
|
|
No comments:
Post a Comment