SELECT
s1.emp_no,
s2.from_date,
s2.salary - s1.salary AS salary_growth
FROM
salaries AS s1,
salaries AS s2
WHERE
s1.emp_no = s2.emp_no
AND strftime ( '%Y', s2.to_date ) - strftime ( '%Y', s1.to_date ) = 1
AND salary_growth > 5000
ORDER BY
salary_growth DESC;
牛客SQL练习-27-给出每个员工每年薪水涨幅超过5000的员工编号emp_no、薪水变更开始日期from_date以及薪水涨幅值salary_growth,并按照salary_growth逆序排列。
最新推荐文章于 2023-12-03 14:15:25 发布