SQLHAVINGaggregationtutorial

What is HAVING in SQL? Filtering groups for beginners

HAVING is the filter that runs after GROUP BY and applies to aggregates. Plain words: WHERE filters input rows, HAVING filters output groups. We'll cover the difference, typical patterns (top-N, anomalies), and why WHERE and HAVING get confused.

May 8, 20261 min readReferenceSQL · HAVING · aggregation · tutorial

HAVING is the filter for groups after GROUP BY. While WHERE filters rows before grouping, HAVING filters the resulting groups based on their aggregates.

This article is currently in Russian. The full English translation is on the way.

PreviousWhat is GROUP BY in SQL? Grouping rows for beginners NextSTRING_AGG in SQL: Concatenate Grouped Rows with a Delimiter and ORDER BY

What are COUNT, SUM, AVG, MIN, MAX in SQL? Aggregate functions for beginners COUNT(*) FILTER (WHERE ...): Conditional Aggregates in One Pass ARRAY_AGG in PostgreSQL: Collect Grouped Values into an Array with ORDER BY and FILTER SQL GROUPING SETS: Subtotals and Grand Totals in One Query