select * from employees
where hire_date like (select hire_date from employees
order by hire_date
where hire_date like (select hire_date from employees
order by hire_date
desc limit 1 offset 2) 跳最大的两行取第三行
或者
select * from employees
where hire_date like (select hire_date from employees
order by hire_date
desc limit 2,1) 从第三行开始取,取一行
where hire_date like (select hire_date from employees
order by hire_date
desc limit 2,1) 从第三行开始取,取一行