what is difference between having and where clause code example
Example: difference between where and having clause
The difference between the having and
where clause in SQL is that the where
clause cannot be used with aggregates(max, min,count,avg,sum)
, but the having clause can.