题解 | #查找最晚入职员工的所有信息#
查找最晚入职员工的所有信息
https://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
select * from employees WHERE hire_date = (SELECT MAX(hire_date) FROM employees); 通过子查询查询出最晚日期,然后根据这个日期去查询
查找最晚入职员工的所有信息
https://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
select * from employees WHERE hire_date = (SELECT MAX(hire_date) FROM employees); 通过子查询查询出最晚日期,然后根据这个日期去查询
相关推荐