根据题目条件,LIMIT和子查询都是可以的,不必纠结:

LIMIT

SELECT * FROM employees ORDER BY hire_date DESC LIMIT 0,1;

子查询

SELECT * FROM employees WHERE hire_date = (
    SELECT max(hire_date) FROM employees)