SQL实战27.给出每个员工每年薪水涨幅超过5000的员工编号emp_no

题目

解答

注意：差一年就是表1截止时间=表二开始时间；提取到的开始时间是涨薪后开始的那一年

select s1.emp_no,s2.from_date,(s2.salary-s1.salary) as salary_growth
from salaries as s1 join salaries as s2 on s1.emp_no=s2.emp_no
and s2.from_date=s1.to_date
where s2.salary-s1.salary>5000
order by salary_growth desc