nowcoder-sql1.查找最晚入职员工的所有信息

一.题目描述

https://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f?tpId=82&&tqId=29753&rp=1&ru=/ta/sql&qru=/ta/sql/question-ranking

二.题目解析

1.相关子查询

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

2.表连接
注意：最晚入职的员工可能有多位

select e.*
from employees e join (select MAX(hire_date) as max_date from employees) h
on e.hire_date = h.max_date;

或者

select e1.* from employees e1 join (select hire_date from employees order by hire_date desc limit 1) e2 on e1.hire_date = e2.hire_date;

（参考：https://blog.nowcoder.net/n/e679357e5f784b0ba83647ffe4d55c94?f=comment）