题目:

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'
本文介绍两种使用SQL查询特定员工薪资增长的方法。方式一利用MAX和MIN函数直接计算薪资范围;方式二通过比较不同时间点的薪资来确定增长值。

被折叠的 条评论
为什么被折叠?



