题解 | 查找最晚入职员工的所有信息
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, row_number()over(order by hire_date desc) r from employees) a where a.r=1
可以先将入职时间排序,再进行查找