Aggregate Function
/ˈæɡrɪɡɪt ˈfʌŋkʃən/
Definition
A SQL function (COUNT, SUM, AVG, MIN, MAX) performing a calculation on a set of rows, returning a single value.
Example in context
"SELECT COUNT(*), AVG(amount) FROM orders WHERE status='completed' GROUP BY user_id."
Practice this term
Master Aggregate Function in context by working through exercises in the Databases & SQL module. You'll see the term used in real engineering scenarios with multiple-choice, fill-in-the-blank, and matching drills.