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