Thursday, March 4, 2010

SQL Server 2005 and 2008 Ranking Functions - Row_Number and Rank

SQL Server 2005 and 2008 Ranking Functions - Row_Number and Rank
SQL Server introduced four different ranking functions either to rank records in a result-set or to rank records within groups of records of a result-set. With this inclusion we are no longer required to write several lines of code to get ranking. It does not only help in simplifying the query, but also improves the performance of the query. So now the questions are, what are these ranking functions, how do they work and how do they differ from each other? This article talks about Row_Number and Rank in detail, click here for more details.

1 comment:

  1. One of the great Information site on SQL Server

    ReplyDelete