SELECT a.* FROM employees a
inner JOIN
(
SELECT a.*, ROW_NUMBER() over(ORDER BY a.hire_date desc) AS num FROM employees a

)b ON a.emp_no =b.emp_no AND b.num=3;

开窗函数是挺好用,不过很难受不能放在where后面,所以还要再关联一遍