一开始做的时候想的也是直接进行查询就行了，后来看了题解区的评论，多看了看大家写的思路，然后就发现自己确实没有想过数据重复的事情，后来又回头做了一遍

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)

select * from employees where

hire_date=(select distinct hire_date from employees

order by hire_date desc limit 1 offset 2)