根据题目给的输出结果来看并没有降薪的人员,最低的也是0。为什么最大-最小没有通过呢? select s.emp_no , max(s.salary)- min(s.salary) as growth from employees e left join salaries s on e.emp_no = s.emp_no where e.emp_no in (select distinct a.emp_no from salaries a where a.to_date = '9999-01-01') group by e.emp_no order by growth asc
1

相关推荐

牛客网
牛客企业服务