Tag Archive

SQL Server Ranking Functions Row_Number(), Rank(), Dense_Rank() and NTIle()

Published on March 26, 2011 By Ahmad Alkilani

SQL Server 2005 introduced new ranking functions. This article is tailored as an introduction to these functions, difference between them and when to use each and a few examples. Ranking What: The new ranking functions are new internal functions to SQL Server 2005/2008. From MSDN “Ranking functions return a ranking value for each row in […]