方案一
- 先查询最晚入职时间,再根据最晚入职时间比对进而得出最晚入职的员工信息
select * from employees as a where a.hire_date = (select max(hire_date) from employees)
方案二
- 使用limit语句(此方案具有局限性,因为不确定一天中是否最多有一个人入职)
select * from employees as a order by a.hire_date desc limit 0,1
select * from employees as a where a.hire_date = (select max(hire_date) from employees)
select * from employees as a order by a.hire_date desc limit 0,1