Learn what the SQL ROW_NUMBER function is, how it works, and how to use it for various database development tasks, such as ranking, ordering, removing duplicates, and pagination.

For more information, see OVER Clause (Transact-SQL). order_by_clause The ORDER BY clause determines the sequence in which the rows are assigned their unique ROW_NUMBER within a specified partition.

I need to query against a column which contains build numbers stored as an NVARCHAR.Sorting works fine until you get into double-digit versions.This works ...