SELECT (
( SELECT salary FROM salaries WHERE emp_no = 10001 ORDER BY to_date DESC LIMIT 1 ) -
( SELECT salary FROM salaries WHERE emp_no = 10001 ORDER BY FROM_date LIMIT 1 )
) AS growth
**注意:**本题干说明最低工资即为入职的工资,最高工资即为最新的工资,可以直接用MAX-MIN得到
SELECT (
( SELECT salary FROM salaries WHERE emp_no = 10001 ORDER BY to_date DESC LIMIT 1 ) -
( SELECT salary FROM salaries WHERE emp_no = 10001 ORDER BY FROM_date LIMIT 1 )
) AS growth
**注意:**本题干说明最低工资即为入职的工资,最高工资即为最新的工资,可以直接用MAX-MIN得到