ROW_NUMBER
Numbering of rows in accordance with the order of values of a primary key
Numbering of a query result set
Paging records
Window functions
ROW_NUMBER function
Ranking functions
Equivalents for analytic functions
MySQL. Usage of query variables
Numbering rows when there are duplicates in the results column
Numbering of a query result set
RANK() and DENSE_RANK() functions
Ranking functions