Aggregate Functions

Aggregate functions are only to be used in a select statement as the field name, several are allowed.

Aggregate functions perform a calculation on a set of values and return a single value.

The following supported aggregate functions are listed below.

Function
MAX()
MIN()
SUM()
AVG()
COUNT()
STDEV()