Tuesday, April 08, 2008

OLAP functions in Oracle:

OLAP functions:

ROW_NUMBER
NTILE
WIDTH_BUCKET
RANK
DENSE_RANK
PERCENT_RANK
PERCENTILE_CONT
LAG
LEAD
SUM, AVG, MIN, MAX, VARIANCE, STDDEV, COUNT
KEEP
OLAP Windows
ROWS
RANGE
ROLLUP / CUBE / GROUPING
CUME_DIST
FIRST_VALUE
LAST_VALUE
RATIO_TO_REPORT

No comments: