题解 | #查找最晚入职员工的所有信息#
- step1:找到最晚的入职时间hire_date
- step2:通过内关联inner join找到最晚入职员工的全部信息
select emp_no
,birth_date
,first_name
,last_name
,gender
,p1.hire_date as hire_date
from(
SELECT emp_no
,birth_date
,first_name
,last_name
,gender
,max(hire_date) as hire_date
from employees
) p1
inner join
(
SELECT max(hire_date) as hire_date
from employees
) p2
on p1.hire_date = p2.hire_date