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

• 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