Aggregate Functions

An aggregate function refers to a set of input values and returns one single result value. If the table is subdivided into several groups with the GROUP BY clause, an aggregate function calculates a value for each of these groups.

If a GROUP BY clause is not stated, an aggregate function always refers to the entire table. This type of query then returns exactly one result row. Aggregate functions are sometimes referred to as set functions.

Exasol supports the following aggregate functions:

ANY

APPROXIMATE_COUNT_DISTINCT

AVG

CORR

COUNT

COVAR_POP

COVAR_SAMP

EVERY

FIRST_VALUE

GROUP_CONCAT

GROUPING[_ID]

LAST_VALUE

LISTAGG

MAX

MEDIAN

MIN

MUL

REGR_FUNCTIONS

SOME

ST_INTERSECTION (Refer to ST_* and Geospatial Data sections for more information)

ST_UNION (Refer to ST_* and Geospatial Data sections for more information)

STDDEV

STDDEV_POP

STDDEV_SAMP

SUM

VAR_POP

VAR_SAMP

VARIANCE