WHERE
Vs HAVING
Where
|
Having
|
1.Without group by
clause
2. Where clause
select Row before grouping.
3. Where clause
can’t contain aggregate function.
|
1.With group by
clause
2.Having clause
select after grouping
3.Having clause
contain aggregate
Function.
|
No comments:
Post a Comment