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