SQL1 查找最晚入职员工的所有信息

SQL1 查找最晚入职员工的所有信息

题目

题解1

select * 
from employees
order by hire_date desc
limit 1;

题解2

select * 
from employees
where hire_date = (select max(hire_date) from employees);