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. |