What does the HAVING clause do in an SQL query?

easy📝 Conceptual Q1 of 15

SQL - GROUP BY and HAVING

What does the HAVING clause do in an SQL query?

AFilters groups after aggregation

BFilters rows before aggregation

CSorts the result set

DJoins two tables

Step-by-Step Solution

Solution:

Step 1: Understand the role of HAVING
The HAVING clause is used to filter groups created by GROUP BY after aggregation functions are applied.
Step 2: Differentiate HAVING from WHERE
WHERE filters rows before grouping, HAVING filters groups after aggregation.
Final Answer:
Filters groups after aggregation -> Option A
Quick Check:
HAVING filters groups = D [OK]

Quick Trick: HAVING filters groups, WHERE filters rows before grouping [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes