#1.对入职时间进行降序排序: order by hire_date desc #2.获取倒三的员工信息:limit(2,1) select* from employees order by hire_date desc limit 2,1