题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息
查找入职员工时间升序排名的情况下的倒数第三的员工所有信息
https://www.nowcoder.com/practice/ec1ca44c62c14ceb990c3c40def1ec6c
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 ranking
from
employees
) a
where
ranking = 3
order by
a.emp_no asc
查看9道真题和解析