Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


HeatWave User Guide  /  ...  /  Aggregate Functions

11.2.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 3.3, “Encoding String Columns”.

Table 11.1 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
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