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

-- 知识点 dense_rank() -- rank() -- row_number() 函数的使用  with temp as ( select *, dense_rank() over (order by hire_date desc ) as rn  from employees ) select emp_no,
birth_date,
first_name,
last_name,
gender,
hire_date from temp where rn=3;