select 
emp_no,
salary,
dense_rank()over(order by salary DESC) as"t_rank"
FROM salaries
order by t_rank ,emp_no