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