SELECT *
FROM employees
WHERE hire_date = (SELECT hire_date
FROM employees
GROUP BY hire_date
Order by hire_date desc
LIMIT 2,1)
Order BY emp_no asc