What is the main purpose of the HAVING clause in a PostgreSQL query?

easy📝 Conceptual Q11 of 15

PostgreSQL - Aggregate Functions and GROUP BY

What is the main purpose of the HAVING clause in a PostgreSQL query?

ATo join two tables

BTo filter rows before grouping

CTo sort the result set

DTo filter groups after aggregation

Step-by-Step Solution

Solution:

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

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

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free