SELECT s1.emp_no, s1.salary, (COUNT(s2.salary))+1 AS t_rank FROM salaries s1 LEFT JOIN (SELECT DISTINCT salary FROM salaries) s2 ON s1.salary<s2.salary GROUP BY emp_no ORDER BY salary DESC, emp_no ASC