使用窗口函数 select a.* from ( select * from employees ) a inner join ( select * from ( select emp_no ,DENSE_RANK()over(order by hire_date desc) as ranking from employees ) t where ranking = 3 ) b on a.emp_no=b.emp_no