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 ...
