# 使用rank窗口函数,在over子句中对表中的数据按照hire_date进行降序排序,然后取排序为3的数据 select emp_no, birth_date, first_name, last_name, gender, hire_date from (select emp_no, birth_date, first_name, last_name, gender, hire_date, dense_rank() over( order by hire_date DESC) as t1 from employees) ...