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