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

考虑去重：

SELECT * 
FROM employees
WHERE hire_date = (
    SELECT DISTINCT hire_date
    FROM employees
    ORDER BY hire_date DESC 
    LIMIT 2,1 
)