difference between having and where in sql code example
Example 1: having clause vs where clause 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.
Example 2: 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,
but the having clause can.