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 rk from employees ) as ab where ab.rk = 3 1.本题得用dense_rank,不能用rank,不然排名第三答案会错2.为什么我用as rank 不行 要用as rk才行,堵了我半天进度!大佬能教一教吗...