题解 | 查找最晚入职员工的所有信息
查找最晚入职员工的所有信息
https://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
# select *
# from employees
# where hire_date in (
# select max(hire_date)
# from employees
# )
# select *
# from employees
# where hire_date = (
# select max(hire_date)
# from employees
# )
select *
from employees
order by
hire_date DESC
limit 0,1;
