SQL - GROUP BY and HAVING
Which of the following is the correct syntax to filter groups with HAVING?
SELECT department, COUNT(*) FROM employees GROUP BY department _______ COUNT(*) > 5;
Which of the following is the correct syntax to filter groups with HAVING?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Identify filtering clause after grouping
AfterGROUP BY, filtering groups requiresHAVING, notWHERE.Step 2: Confirm correct clause usage
HAVING COUNT(*) > 5filters groups with more than 5 employees.Final Answer:
HAVING -> Option DQuick Check:
Use HAVING after GROUP BY [OK]
Quick Trick: Use HAVING to filter groups, not WHERE [OK]
Common Mistakes:
MISTAKES- Using WHERE instead of HAVING after GROUP BY
- Placing HAVING before GROUP BY
- Using FILTER keyword which is invalid here
Master "GROUP BY and HAVING" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes