Home / Glossary / GROUP BY

GROUP BY

SFBy Sitraka Forler · Lecturer, Durham Business School·Updated 13 September 2026· About this site

Aggregates rows that share a column value.

GROUP BY collapses rows into groups and lets aggregate functions (COUNT, SUM, AVG, MAX, MIN) operate on each group. Every column in SELECT must either be in GROUP BY or wrapped in an aggregate.

SELECT ticker, AVG(close) AS avg_price
FROM equity_prices
GROUP BY ticker;