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