select * from employees
where hire_date = (select distinct hire_date from employees
order by hire_date desc
limit 2,1)

一种思路，供参考。主要在于对入职日期进行去重