2.12.1 Aggregate Functions

The following table shows supported aggregate functions. The VARLEN Support column identifies functions that support variable-length encoded string columns. See Section 2.7.1, “Encoding String Columns”.

Table 2.2 Aggregate (GROUP BY) Functions

Name	VARLEN Support	Description
AVG()		Return the average value of the argument
COUNT()	Yes	Return a count of the number of rows returned
COUNT(DISTINCT)		Return the count of a number of different values
GROUP_CONCAT()		Return a concatenated string. Supported with variable-length (VARLEN) string columns. Limitations apply. See Section 2.16.3, “Functions and Operator Limitations”.
MAX()	Yes	Return the maximum value
MIN()	Yes	Return the minimum value
STD()		Return the population standard deviation
STDDEV()		Return the population standard deviation
STDDEV_POP()		Return the population standard deviation
STDDEV_SAMP()		Return the sample standard deviation
SUM()		Return the sum
VAR_POP()		Return the population standard variance
VAR_SAMP()		Return the sample variance
VARIANCE()		Return the population standard variance