Beginner
Database Management Systems
Q16 / 100
What is the difference between WHERE and HAVING?
Correct! Well done.
Incorrect.
The correct answer is A) WHERE filters rows before grouping; HAVING filters groups after grouping
A
Correct Answer
WHERE filters rows before grouping; HAVING filters groups after grouping
Explanation
WHERE filters rows before GROUP BY aggregation. HAVING filters groups after aggregation. You can't use aggregate functions in WHERE: use HAVING COUNT(*) > 5 not WHERE COUNT(*) > 5.
Progress
16/100