题解 | #查找在职员工自入职以来的薪水涨幅情况#

1.找到最后的薪资 2.找到入职时的工资 3.求差

select q1.emp_no, q1.salary - min as growth from (select emp_no, salary from salaries where to_date = '9999-01-01') q1

join

(select t1.emp_no, t1.salary as min from ( select * from salaries where emp_no in (select emp_no from salaries where to_date ='9999-01-01')) t1 join ( select emp_no,min(from_date) as mindate from salaries group by emp_no) t2 on t1.emp_no = t2.emp_no where t1.from_date = t2.mindate) q2 on q1.emp_no = q2.emp_no order by growth