方法一:排序后分页
SELECT * FROM EMPLOYEES ORDER BY HIRE_DATE DESC LIMIT 1;
方法二:组合查询,先查询最晚入职时间,再定位到数据
SELECT * FROM EMPOLYEES WHERE HIRE_DATE = (SELECT MAX(HIRE_DATE)) FROM EMPOLYEES);
SELECT * FROM EMPLOYEES ORDER BY HIRE_DATE DESC LIMIT 1;
SELECT * FROM EMPOLYEES WHERE HIRE_DATE = (SELECT MAX(HIRE_DATE)) FROM EMPOLYEES);