nowcoder-sql2-查找入职员工倒数第三的员工信息

limit：作用：第一个参数是查询结果的偏移量，第二个参数是返回的个数

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