查找员工编号emp_now为10001其自入职以来的薪水salary涨幅值growth

题目:

sql语句

方式一:
SELECT (MAX(salary)-MIN(salary)) AS growth 
FROM salaries WHERE emp_no = '10001'

方式二:

select DISTINCT ((select s1.salary from salaries s1  where s1.emp_no = '10001' and  s1.to_date = '9999-01-01')-(select s2.salary from salaries s2 ,employees e where e.hire_date = s2.from_date and s2.emp_no = '10001')) as growth from salaries s3  where s3.emp_no = '10001'