SQL - GROUP BY and HAVING
Which clause is used to filter groups based on aggregate values in SQL?
Which clause is used to filter groups based on aggregate values in SQL?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify filtering clauses
WHERE filters individual rows, HAVING filters groups after aggregation.Step 2: Confirm HAVING filters on aggregate values
HAVING can use aggregate functions like SUM, COUNT to filter groups.Final Answer:
HAVING -> Option DQuick Check:
Filter groups by aggregate = A [OK]
Quick Trick: Use HAVING to filter groups after aggregation [OK]
Common Mistakes:
MISTAKES- Using WHERE to filter aggregated groups
- Confusing GROUP BY as a filtering clause
Master "GROUP BY and HAVING" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes