select emp_no, salary, DENSE_RANK() OVER (ORDER BY salary desc) as t_rank
from salaries
order by salary desc, emp_no;