Ranking Functions in SQL Server 2005

ROW_NUMBER () OVER ([] ) 
RANK () OVER ([] ) 
DENSE_RANK () OVER ([] ) 
NTILE (integer_expression) OVER ([] )

 SELECT ROW_NUMBER() OVER (ORDER BY FieldName ASC) AS ROWNO, * FROM Table_Name