PARTITION BY
ROW_NUMBER function
About ranking functions
Other examples of using window functions
About window functions
RANK() and DENSE_RANK() functions
About ranking functions
About window functions
New sql features
LAG and LEAD functions
About window functions
NTILE function
About ranking functions