MySQL 8 Cookbook

Row number

You can get the row number for each row to rank the results:

mysql> SELECT CONCAT(first_name, " ", last_name) AS full_name, salary, ROW_NUMBER() OVER(ORDER BY salary DESC) AS 'Rank'  FROM employees JOIN salaries ON salaries.emp_no=employees.emp_no LIMIT 10;+-------------------+--------+------+| full_name         | salary | Rank |+-------------------+--------+------+| Tokuyasu Pesch    | 158220 |    1 || Tokuyasu Pesch    | 157821 |    2 || Honesty Mukaidono | 156286 |    3 || Xiahua Whitcomb   | 155709 |    4 || Sanjai Luders     | 155513 |    5 || Tsutomu Alameldin | 155377 |    6 || Tsutomu Alameldin | 155190 |    7 || Tsutomu Alameldin | 154888 |    8 || Tsutomu Alameldin | 154885 |    9 || Willard Baca      | 154459 |   10 |+-------------------+--------+------+10 rows in set (6.24 ...