题解 | #查找最晚入职员工的所有信息#
查找最晚入职员工的所有信息
http://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
- 先用hire_date反排序（order by XXX desc），然后select all
select * from employees as latest
order by hire_date desc limit 1
- 使用select max()选出hire_date最大值，然后用where筛选出和最大值一样的hire_date，最后select all
select * from employees as latest
where latest.hire_date = (select max(hire_date) from employees)
抖音泡池子1人在聊