Aggregrate Analytical 21 | Analytical Functions Basics 12 |
Centered Average 1 | Compute 3 |
connect by 3 | Corr 1 |
COVAR_POP 1 | COVAR_SAMP 1 |
Cube 10 | CUME_DIST 3 |
Cumulative Sum 8 | CURRENTV 2 |
DENSE_RANK 13 | First Last Value 11 |
First Last 1 | GROUPING SETS 2 |
GROUPING 7 | GROUPING_ID 4 |
IGNORE NAV KEEP NAV 1 | IS PRESENT 1 |
LAG LEAD 10 | Measure 3 |
MEDIAN 2 | Model 2 |
Moving Average 1 | NTILE 8 |
NULLs First 3 | NULLs Last 5 |
Over 11 | PARTITION 14 |
percentile_cont 1 | PERCENTILE_DISC 1 |
PERCENT_RANK 4 | PRESENTV 1 |
Range 3 | Rank Row 1 |
Rank 12 | Ratio Portion 1 |
RATIO_TO_REPORT 6 | REGR_AVGX 2 |
REGR_AVGY 1 | REGR_COUNT 2 |
REGR_INTERCEPT 2 | REGR_R2 2 |
REGR_SLOPE 2 | REGR_SXX 2 |
REGR_SXY 2 | REGR_SYY 3 |
Rollup 12 | ROW_NUMBER 11 |
RULES UPDATE 1 | Start With 3 |
STATS_MODE 1 | STATS_WSR_TEST 3 |
STDDEV 2 | STDDEV_POP 1 |
STDDEV_SAMP 1 | Sum 5 |
Top Values 1 | UNBOUNDED FOLLOWING 1 |
VARIANCE 2 | VAR_POP 1 |
VAR_SAMP 1 |