题解 | #查找在职员工自入职以来的薪水涨幅情况#

• 请你查找在职员工自入职以来的薪水涨幅情况;
• 给出在职员工编号emp_no以及其对应的薪水涨幅growth;
• 并按照growth进行升序;

SELECT sal1.emp_no, sal1.salary - sal2.min_sal AS growth
FROM salaries sal1, (SELECT emp_no, MIN(salary) AS min_sal
FROM salaries
GROUP BY emp_no) AS sal2
WHERE sal1.to_date = '9999-01-01' AND sal1.emp_no = sal2.emp_no
ORDER BY growth;