解法一:where 子查询 +limit
1、查询入职日期排名倒数第三的日期
select hire_date from employees order by hire_date desc limit 2,12、筛选入职日期等于1表范围的用户信息
select * from employees where hire_date = (select hire_date from employees order by hire_date desc limit 2,1);
解法二、窗口函数dense_rank()排名
1、用dense_rank()对日期进行倒序排名
SELECT *,DENSE_RANK() over(order by hire_date desc) as rnk from employees2、在1表中筛选排名等于3的用户信息
select a.emp_no,a.birth_date,a.first_name,a.last_name,a.gender,a.hire_date from (SELECT *,DENSE_RANK() over(order by hire_date desc) as rnk from employees) as a where rnk=3;