select emp_no, (max(salary)-min(salary)) as growth from salaries where emp_no = (select emp_no from salaries where to_date = '9999-01-01') group by emp_no order by growth asc
2

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务