aggregate function

noun
UK /ˈæɡrɪɡət ˈfʌŋkʃən/
US /ˈæɡrɪɡət ˈfʌŋkʃən/

A tool that adds up or combines many pieces of information into one answer.

The teacher used an aggregate function to find the total score of the whole class.

SYNONYMS

summary functioncombining functiontotaling functiongrouping function

RELATED WORDS

databasespreadsheetcalculationstatisticsquery

OTHER MEANINGS

2. In computing, a routine that takes a set of values and returns a single value, such as SUM, COUNT, or AVERAGE.

SQL provides aggregate functions like SUM and COUNT to summarize table data.

3. In mathematics, a function whose input is a collection of values and whose output is one combined value.

The average is an aggregate function of a list of numbers.

4. A function used in data analysis to condense many records into a single summary figure.

The report used an aggregate function to show monthly sales totals.