法1：窗口函数注意这里要用dense_rank()不能用rank()，否则甚至可能跳过排序3 select emp_no,birth_date ,first_name ,last_name ,gender ,hire_date from (select emp_no,birth_date ,first_name ,last_name ,gender ,hire_date ,dense_rank()over(order by hire_date desc) rk from employees ) as new where rk=3 order by emp_no 法2：子查询+limit s...
