ROW_NUMBER()开窗函数还可以取指定顺序的数据
select emp_no,salary from
(select *,
row_number() over(order by salary desc) n from salaries
where to_date="9999-01-01"
) t
where t.n=2