ROW_NUMBER (Transact-SQL) - TechNet - Microsoft

Returns the sequential number of a row within a partition of a result set, starting at 1 ... Transact-SQL Syntax Conventions ... GO SELECT ROW_NUMBER() OVER( ORDER BY SalesYTD DESC) AS Row, ...

technet.microsoft.com