techmixing.com
Ranking Functions in SQL Server - Technology with Vivek Johari
Ranking functions on SQL Server, ROW_NUMBER(), RANK (), DENSE_RANK() & NTILE() is used to provide a Row number to the rows in a table or within a partition.