Analytical Functions « Oracle PL / SQL





Analytical Functions /

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