SELECT
e.emp_no,
(a.salary - b.salary) AS growth
FROM
employees e
INNER JOIN salaries a ON e.emp_no = a.emp_no
AND a.to_date = '9999-01-01'
INNER JOIN salaries b ON e.emp_no = b.emp_no
AND b.from_date = e.hire_date
ORDER BY
growth ASC;
牛客SQL练习-21-查找所有员工自入职以来的薪水涨幅情况,给出员工编号emp_no以及其对应的薪水涨幅growth,并按照growth进行升序
最新推荐文章于 2021-12-22 15:08:59 发布