Aggregate Functions
An aggregate function performs a calculation on a set of values, and returns a single value. Except for COUNT(*), aggregate functions ignore null values. Aggregate functions are often used with the GROUP BY clause of the SELECT statement.
| FUNCTION | DESCRIPTION |
|---|---|
| AVG | The average of all values contained in the group. |
| COUNT | The number of values contained in the group |
| MAX | The maximum value for a specified group. |
| MIN | The maximum value for a specified group. |
| STDEV | The sample standard deviation of the values contained in a group |
| STDEVP | The population standard deviation of the values contained in a group |
| SUM | The sum of all values contained in the group. |
| VAR | The sample variance of the values contained in a group |
| VARP | The population variance of the values contained in a group |