要考虑入职同一天的不止一个员工，要用子查询。

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