The HAVING clause was added to SQL because the WHERE keyword could be used with aggregate functions.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- The WHERE keyword cannot be used with aggregate functions.
- WHERE keyword could not be used with aggregate functions.
- You must also use the GROUP BY clause whenever using the HAVING clause.
- What does the HAVING clause do?
- In a select with a group by clause, a where clause, and a having clause, the where conditions are applied b...
- We can use both HAVING and WHERE SQL clauses in one SQL statement.
- Can you use both HAVING and WHERE Sql clauses in one SQL statement ?
- When do we use a HAVING clause?