SQL Server ROW_NUMBER Function

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