题解 | #查找入职员工时间排名倒数第三的员工所有信息#

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


用 offset 去掉第一第二条
mysql里分页一般用limit来实现
1. select* from article LIMIT 1,3
2. select * from article LIMIT 3 OFFSET 1
上面两种写法都表示取2,3,4三条条数据