题目:查找所有员工自入职以来的薪水涨幅情况,给出员工编号emp_no以及其对应的薪水涨幅growth,并按照growth进行升序解题要领:构建现在的工资表和入职的工资表,然后做差隐含题意:现在对应的时间是to_date=‘9999-01-01’,入职则需要利用employees表的hire_date字段 方法1:利用左外连接创建Scurrent表和Sstart表SELECT sCurrent.emp_no, (sCurrent.salary-sStart.salary) AS growthFROM (SELECT e.emp_no, s.salary FROM employees AS e L...