#第一步:查询出当前员工工资 select emp_no,salary from salaries where to_date="9999-01-01"; #第二步:查询出员工入职时的工资 select s.emp_no,s.salary from salaries as s inner join employees as e on s.emp_no = e.emp_no and s.from_date =e.hire_date; #第三步:链接两表得到一张新表,包含目前还在职的员工,当前的薪酬情况和入职时的薪酬情况,计算薪酬涨幅情况,并按照growth进行升序 select t1.emp_no,(t1.salary-t2.salary)as growth from (select emp_no,salary from salaries where to_date="9999-01-01") as t1 inner join (select s.emp_no,s.salary from salaries as s inner join employees as e on s.emp_no = e.emp_no and s.from_date =e.hire_date) as t2 on t1.emp_no = t2.emp_no order by growth asc;