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