题解 | #查找入职员工时间排名倒数第三的员工所有信息#
查找入职员工时间排名倒数第三的员工所有信息
https://www.nowcoder.com/practice/ec1ca44c62c14ceb990c3c40def1ec6c
(select b.emp_no, b.birth_date, b.first_name, b.last_name, b.gender, b.hire_date from (select *,Dense_Rank() over (order by hire_date desc) as ranking from employees c) b where b.ranking = 3);
查看5道真题和解析