what is the difference between having and where in sql code example
Example: having vs where sql
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.