How to use ROW_NUMBER Function in SQL Server

By FoxLearn 2/16/2024 4:45:20 AM   194
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

Result

OrderFirstNameLastNameCity
1Lucy NULL
2Tom NewYork

The ROW_NUMBER() function is useful for pagination, It is a temporary value calculated when the query is run.