Numbering
Numbering of rows in accordance with the order of values of a primary key
Numbering of a query result set
ROW_NUMBER function
Ranking functions
Numbering of a query result set
Typical problems
Numbering rows when there are duplicates in the results column
Numbering of a query result set