RANKING FUNCTIONS + SQL SERVER

1. ROW_NUMBER

• http://technet.microsoft.com/en-us/library/ms186734.aspx

1. RANK
• http://technet.microsoft.com/en-us/library/ms176102.aspx
2. NTILE
• http://technet.microsoft.com/en-us/library/ms175126.aspx
3. DENSE_RANK 
• http://technet.microsoft.com/en-us/library/ms173825.aspx

Examples :

-- Add the SrNo value
SELECT ROW_NUMBER() OVER(ORDER BY ID Asc) AS SrNo,Col1,Col2
FROM Table1
Order By ID