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