Aggregate Function
noun
say it: “AG-ruh-git FUNGK-shun” /ˈæɡrɪɡɪt ˈfʌŋkʃən/
A SQL function that turns many rows into one value, such as COUNT, SUM, AVG, MIN or MAX.
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;
In a sentence
- “SUM is an aggregate function: it adds up a whole column into one total.”
Level: Apprentice · More SQL terms at this level
Updated