题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息
查找入职员工时间升序排名的情况下的倒数第三的员工所有信息
https://www.nowcoder.com/practice/ec1ca44c62c14ceb990c3c40def1ec6c
select s1.* from employees as s1 inner join (select hire_date,rank() over(order by hire_date desc) as rk from (SELECT DISTINCT hire_date FROM employees) as p1) as s2 on s1.hire_date=s2.hire_date where rk=3 order by s1.hire_date,s1.emp_no;
#一开始理解错了，以为是员工按时间排序下的倒数第三，结果居然是时间单独排序倒数第三 哈哈
