数据库SQL实战 No.21
查找所有员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/questionTerminal/fc7344ece7294b9e98401826b94c6ea5
SELECT hire_date.emp_no, (up_to_date.salary-hire_date.salary) AS growth
FROM (SELECT e.emp_no, s.salary
FROM employees e JOIN salaries s
ON e.emp_no = s.emp_no
AND e.hire_date = s.from_date) AS hire_date
JOIN (SELECT e.emp_no, s.salary
FROM employees e JOIN salaries s
ON e.emp_no = s.emp_no
WHERE s.to_date = '9999-01-01') AS up_to_date
ON hire_date.emp_no = up_to_date.emp_no
ORDER By growth
数据库SQL实战答案 文章被收录于专栏
该专栏为“数据库SQL实战”的配套题解
，结果一看是南大本硕✌️
，肯定没有问题的
投递小米集团等公司10个岗位