嘿嘿嘿

方案一

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