题解 | #查找入职员工时间排名倒数第三的员工所有信息#

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