题解 | #查找最晚入职员工的所有信息#
查找最晚入职员工的所有信息
http://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
思路
法一：
# 1.先找出最晚入职的日期
select hire_date from employees
group by hire_date
order by hire_date desc
limit 0,1;
# 2.再以最晚入职日期去匹配员工
select * from employees
where hire_date=
(
select hire_date from employees
group by hire_date
order by hire_date desc
limit 0,1;
)
法二：
select * from employees
where hire_date =
(select max(hire_date) from employees)
虎牙一面16人在聊
查看9道真题和解析
