Analytical Functions « Oracle PL / SQL






Analytical Functions /

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