<< Active transactions | IBExpert Glossary | Alias >>

A function that performs a computation on a set of values rather than on a single value, to calculate group-level totals and statistics. For example, finding the average or mean of a list of numbers is an aggregate function.

All database management and spreadsheet systems support a set of aggregate functions that can operate on a set of selected records or cells.

Aggregate functions perform calculations over a series of values, such as the columns retrieved with a SELECT statement. These include AVG(), COUNT(), MAX(), MIN(), SUM().

See also:
Conversion Functions
Window (Analytical) functions (Firebird 3.0)
Firebird Null Guide: Aggregate functions
Firebird 2.5 Language Reference Update & Firebird 2.1 Language Reference: Aggregate functions: extended functionality

<< Active transactions | IBExpert Glossary | Alias >>