Reference Guide > TDV Support for SQL Functions > TDV-Supported Aggregate Functions
 
TDV-Supported Aggregate Functions
Aggregate functions compare or combine values in a column and return a single result based on those values.
Certain restrictions apply to the use of aggregate functions with the DISTINCT clause. See DISTINCT in Aggregate Functions.
If any column in the SELECT clause is outside of an aggregate function, you must also include the column in the GROUP BY clause. See the example given for AVG.
TDV supports the aggregate functions listed in the table below.
TDV-Supported Aggregate Function
Comments
AVG
See AVG.
CORR
See description of the analytical form of this function, CORR.
COUNT
See COUNT.
COVAR_POP
See description of the analytical form of this function, COVAR_POP.
COVAR_SAMP
See description of the analytical form of this function, COVAR_SAMP.
LISTAGG
See description of the analytical form of this function, LISTAGG.
MAX
See MAX.
MEDIAN
 
MIN
See MIN.
PERCENTILE
 
PERCENTILE_APPROX
 
PERCENTILE_CONT
See description of the analytical form of this function, PERCENTILE_CONT.
PERCENTILE_DISC
See description of the analytical form of this function, PERCENTILE_DISC.
REGR_AVGX
See description of the analytical form of this function, REGR_AVGX.
REGR_AVGY
See description of the analytical form of this function, REGR_AVGY.
REGR_COUNT
See description of the analytical form of this function, REGR_COUNT.
REGR_INTERCEPT
See description of the analytical form of this function, REGR_INTERCEPT.
REGR_R2
See description of the analytical form of this function, REGR_R2.
REGR_SLOPE
See description of the analytical form of this function, REGR_ SLOPE.
REGR_SXX
See description of the analytical form of this function, REGR_SXX.
REGR_SXY
See description of the analytical form of this function, REGR_SXY.
REGR_SYY
See description of the analytical form of this function, REGR_SYY.
STDDEV
See description of the analytical form of this function, STDDEV.
STDDEV_POP
See description of the analytical form of this function, STDDEV_POP.
STDDEV_SAMP
See description of the analytical form of this function, STDDEV_SAMP.
SUM
See SUM.
SUM_FLOAT
 
VARIANCE
See description of the analytical form of this function, VARIANCE.
VARIANCE_POP
See description of the analytical form of this function, VAR_POP.
VARIANCE_SAMP
See description of the analytical form of this function, VAR_SAMP.
XMLAGG
See XMLAGG.