SELECT last_salary_t.emp_no,(last_salary_t.salary-hire_salary_t.salary)as growth
FROM
(SELECT e.emp_no,salary
FROM employees as e
JOIN salaries as s
ON s.emp_no=e.emp_no
# WHERE hire_date!=from_date) 注意这种写法是错的，因为这样做并没有只筛选在职员工，这样的话输出时会出现growth等于0，growth等于0的话在这个例子里就是离职员工的数据，因此我们要用下面的语句做筛选
WHERE to_date='9999-01-01')
as last_salary_t
JOIN
(SELECT s.emp_no,salary
FROM salaries as s
JOIN employees as e
ON e.emp_no=s.emp_no
WHERE hire_date=from_date)as hire_salary_t
ON hire_salary_t.emp_no=last_salary_t.emp_no
ORDER BY growth
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
