Overblog
Follow this blog Administration + Create my blog

SQL Server Rank functions, RANK, NTILE, DENSE_RANK, ROW_NUMBER

April 20 2010 , Written by Balavardhan Reddy Published on #SQL Server2005

Transact-SQL provides the following ranking functions: -RANK -NTILE -DENSE_RANK -ROW_NUMBER Rank() - Applies to monotonically increasing number for each value in the set Row_Number() - simply assigns sequential numbering to the records of a result-set...

Read more