用完窗口函数，不要忘了再排序
select
emp_no,salary,dense_rank()over(order by salary desc)as t_rank
from
salaries
where
to_date="9999-01-01"
order by
t_rank,emp_no