This post show you how to use ROW_NUMBER Function in SQL Server.
Syntax of the ROW_NUMBER() function:
ROW_NUMBER() OVER (
[PARTITION BY partition_expression, ... ]
ORDER BY sort_expression [ASC | DESC], ...
)
For example:
SELECT ROW_NUMBER() OVER (ORDER BY FirstName) as Order, FirstName, LastName, City
FROM Customers