题解 | #查找最晚入职员工的所有信息#

步骤分解

1. 查找最晚入职时间

   select max(hire_date) from employees;

2. 查找入职时间为1的员工的所有信息

   select * from employees
    where hire_date = (select max(hire_date) from employees);
   

完整答案

select * from employees
    where hire_date = (select max(hire_date) from employees);