方案一

  1. 同上一条
    select *
from employees a 
where a.hire_date in (
 select distinct hire_date
 from employees 
 order by hire_date desc 
 limit 2,1
)

方案二

  1. 有漏洞
    select *
from employees
order by hire_date desc 
limit 2,1