查找按某列排序后的第n个值

查看每个部门中薪水排第三的人的信息

select * from (
select e.employee_id,
       e.first_name,
       department_id,
       salary,
       row_number() over(partition by department_id order by salary desc) rn
  from employees e ) where rn = 3;