Oracle Analytic Aggregate Function Support
TDV supports the analytic aggregate functions listed in the table below for Oracle.
Analytic functions are commonly used in data warehousing environments. They are all push-only functions.
Oracle Analytic Aggregate Function | Notes |
LAST_VALUE | |
PERCENTILE_CONT | |
PERCENTILE_DISC | |
STDDEV | |
STDDEV_POP | |
STDDEV_SAMP | |
VAR_POP | Same as VARIANCE_POP. |
VAR_SAMP | Same as VARIANCE_SAMP. |
VARIANCE | |
VARIANCE_POP | |
VARIANCE_SAMP | |