题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#

利用distinct子查询

select emp_no,salary
from salaries

where to_date = '9999-01-01'
and salary = (
    select distinct salary
    from salaries
    order by salary desc
    limit 1 offset 1
);

窗口函数

select emp_no,salary
from 
(
    select emp_no,salary,dense_rank() over (order by salary desc ) as r
    from salaries
    where to_date = '9999-01-01' 
) as t
where r = 2;