题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息

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