select
  emp_no,
  salary
from
(
    select
      emp_no,
      salary,
      dense_rank() over(
        order by
          salary desc
      ) psn
    from
      salaries
  ) rk
where
  rk.psn = 2

还是排序窗口函数最简单啦