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