Ranking Functions in SQL SERVER 2008

Ranking functions are used to provide simple analytics such as statistical ordering or segmentation. In this Article, you learn how to use the four ranking functions that ship with SQL Server 2008. T-SQL has four functions that can be used for ranking data: ROW_NUMBER, RANK, DENSE_RANK, NTILE