Vertica Analytic Function | Notes |
AVG | |
CORR | |
COUNT | |
COVAR_POP | |
COVAR_SAMP | |
CUME_DIST | |
DENSE_RANK | |
EXPONENTIAL_MOVING_AVERAGE | . |
FIRST_VALUE | |
LAG | |
LAST_VALUE | |
LEAD | |
MAX | |
MEDIAN | |
MIN | |
NTILE | |
PERCENT_RANK | |
PERCENTILE_CONT | |
PERCENTILE_DISC | |
RANK | |
ROW_NUMBER | |
STDDEV | |
STDDEV_POP | |
STDDEV_SAMP | |
SUM | |
VAR_POP | |
VAR_SAMP | |
VARIANCE |