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

看到很多人都是用的先去重得到倒三的hire_date再select，感觉dense rank逻辑更简单点

with ranked as (select *, dense_rank () over (order by hire_date DESC) as dr
from employees)
select emp_no,
birth_date,
first_name,
last_name,
gender, hire_date from ranked
where dr = 3