题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select a.emp_no,(b.salary-a.mi) growth
from (select emp_no,min(salary)mi from salaries group by emp_no)a
join (select emp_no,salary from salaries where to_date='9999-01-01')b
on a.emp_no=b.emp_no order by growth;
from (select emp_no,min(salary)mi from salaries group by emp_no)a
join (select emp_no,salary from salaries where to_date='9999-01-01')b
on a.emp_no=b.emp_no order by growth;