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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment