Introduction
Aggregate functions perform calculations on a set of values and return a single value. With the exception of the COUNT aggregate function, all other aggregate functions ignore NULL Values.
Aggregate functions are frequently used with the GROUP BY clause of the SELECT Statement.
List of Aggregate Functions
- AVG
- CHECKSUM_AGG
- COUNT
- COUNT_BIG
- MAX
- MIN
- SUM
- STDEV
- STDEVP
- VAR
- VARP
See all available data
Explaining the above functions: