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

使用窗函数 dense_rank()