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