Aggregate Function

A function that summarizes a set of rows into one value.

What is Aggregate Function in a relational database?

Aggregate Function — A function that summarizes a set of rows into one value.

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