SQL实战21.查找所有员工自入职以来的薪水涨幅情况

题目

解答

注意：入职时的工资：入职时间=薪资开始时间；当前工资：薪资结束时间为无穷

select a.emp_no,a.salary-b.min_salary as growth
from 
(select emp_no,salary from salaries where to_date = '9999-01-01') a ,
(select emp_no,min(salary) as min_salary from salaries group by emp_no) b
where a.emp_no = b.emp_no
order by growth;