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后面,所以还要再关联一遍
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后面,所以还要再关联一遍