存在重复排名的数据
select * from employees
where hire_date=(
select distinct hire_date from employees
order by hire_date desc limit 1 offset 2
) ;
存在重复排名的数据
select * from employees
where hire_date=(
select distinct hire_date from employees
order by hire_date desc limit 1 offset 2
) ;