补一下第一题
思路:主要考虑到可能不止一个员工是最晚入职的,所以order by limit 等不适用本题
select *
from employees
where hire_date = (select max(hire_date) from employees)
补一下第一题
思路:主要考虑到可能不止一个员工是最晚入职的,所以order by limit 等不适用本题
select *
from employees
where hire_date = (select max(hire_date) from employees)