GROUP BY

A clause collecting rows with equal grouping values so each group produces one result row.

What is GROUP BY in a relational database?

GROUP BY — A clause collecting rows with equal grouping values so each group produces one result row.

SELECT customer_id, COUNT(*) AS order_count
FROM purchase_order
GROUP BY customer_id;

Level: Apprentice · More Database terms at this level

Updated September 27, 2026