Answers for "what is the difference between where and having clause in sql"

SQL
18

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.
Posted by: Guest on January-07-2021
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.
Posted by: Guest on January-07-2021

Code answers related to "what is the difference between where and having clause in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language