select emp_no, birth_date, first_name, last_name, gender, hire_date from (select *, dense_rank()over(order by hire_date desc) as posn from employees) as rk where rk.posn = 3 有大佬觉得这个怎么样