Documentation Home
MySQL HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.4Mb
PDF (A4) - 1.4Mb


MySQL HeatWave User Guide  /  ...  /  Aggregate Functions

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