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