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