select
    emp_no,
    salary,
    dense_rank() over(order by salary desc) as t_rank
from salaries
order by t_rank asc, emp_no asc