题解 | #查找最晚入职员工的所有信息#
查找最晚入职员工的所有信息
http://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
法1.
select * from (select * from employees order by hire_date desc) as a limit 1;
法2.
select * from employees order by hire_date desc limit 1;
法3.
select * from employees where hire_date=(select max(hire_date) from employees);

查看1道真题和解析