思路：按薪水排序，找到排序=2的员工
select
emp_no
,salary
from
(
select
emp_no
,salary
,dense_rank()over(order by salary desc) rk
from salaries
) a
where rk = 2