题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
- 请你查找在职员工自入职以来的薪水涨幅情况;
- 给出在职员工编号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;
