Oracle PL/SQL/Analytical Functions — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
| |
Версия 13:45, 26 мая 2010
- Aggregrate Analytical
- Analytical Functions Basics
- COVAR_POP
- COVAR_SAMP
- CUME_DIST
- CURRENTV
- Centered Average
- Compute
- Corr
- Cube
- Cumulative Sum
- DENSE_RANK
- First Last
- First Last Value
- GROUPING
- GROUPING SETS
- GROUPING_ID
- IGNORE NAV KEEP NAV
- IS PRESENT
- LAG LEAD
- MEDIAN
- Measure
- Model
- Moving Average
- NTILE
- NULLs First
- NULLs Last
- Over
- PARTITION
- PERCENTILE_DISC
- PERCENT_RANK
- PRESENTV
- RATIO_TO_REPORT
- REGR_AVGX
- REGR_AVGY
- REGR_COUNT
- REGR_INTERCEPT
- REGR_R2
- REGR_SLOPE
- REGR_SXX
- REGR_SXY
- REGR_SYY
- ROW_NUMBER
- RULES UPDATE
- Range
- Rank
- Rank Row
- Ratio Portion
- Rollup
- STATS_MODE
- STATS_WSR_TEST
- STDDEV
- STDDEV_POP
- STDDEV_SAMP
- Start With
- Sum
- Top Values
- UNBOUNDED FOLLOWING
- VARIANCE
- VAR_POP
- VAR_SAMP
- connect by
- percentile_cont
