with a as( select emp_no from salaries where to_date = '9999-01-01' #找到符合要求的emp_no ), b as( select s.emp_no ,salary, rank()over(partition by s.emp_no order by from_date ) r from salaries s, a where s.emp_no = a.emp_no #排序 ), e as( select s.emp_no ,salary, rank()over(partition by s.emp_no order by fr...