select * from employees where hire_date=(select max(hire_date) from employees);
select * from employees order by hire_date desc limit 0,1;
select * from employees where hire_date in (select max(hire_date) from employees);
select e1.* from employees e1 join (select hire_date from employees order by hire_date desc limit 1) e2 on
e1.hire_date=e2.hire_date;
select e1.* from employees e1 left join employees e2 on e1.hire_date<e2.hire_date w
数据库练习
最新推荐文章于 2024-06-15 20:21:51 发布