select emp_no, salary, 
    dense_rank() over(order by salary desc) as rk
from salaries
where to_date = '9999-01-01'
order by salary desc, emp_no asc

终于懂最后一行了，同时有desc降序和asc升序时要每一个都区分标注好