刚刚没看时间条件，但是我现在还是想说一句，困难就这啊？select a.emp_no,MAX(salary)-MIN(salary) as growth from employees a inner join salaries b on a.emp_no=b.emp_no where a.emp_no in(select a.emp_no from employees a inner join salaries b on a.emp_no = b.emp_no where from_date <> '9999-01-01' and to_date = '9999-01-01') group by a.emp_no order by growth desc