OVER

Paging records

Window functions

ROW_NUMBER function

Ranking functions

Running totals

Correlated subqueries

Other examples of using window functions

Window functions

RANK() and DENSE_RANK() functions

Ranking functions

LAG and LEAD functions

Window functions

NTILE function

Ranking functions

Window functions

New sql features