PARTITION BY

ROW_NUMBER function

Ranking functions

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