Practical Oracle SQL: Mastering the Full Power of Oracle Database

Index

A

Accumulated sum

SeeRolling sum

Analytic functions

avg

sliding windows for centered moving average

dense_rank

restart ranking usingpartition by

lag

last_value

case expression to createnull on rows of group except the first

ignore nulls

lead

case expression to createnull on undesired rows

emulatingconnect_by_isleaf inwith clause recursion

ignore nulls

look more than one row ahead using second parameter

null at end of partition

ntile

order by clause

analyticorder by different than queryorder by

over

query partition clause

rank

regr_intercept

regr_slope

row_number

emulatingminus all

emulating multi-column scalar subquery

sum

See alsoRolling sum

windowing clause

default window clause dangers

number of rowspreceding orfollowing

range between

range ...