题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select mi.emp_no,(max_salary-min_salary)as growth from
(select emp_no,min(salary) as min_salary from salaries
group by emp_no ) as mi,
(select emp_no,max(salary) as max_salary from salaries
where to_date = '9999-01-01'
group by emp_no) as ma
where mi.emp_no = ma.emp_no
order by growth;
(select emp_no,min(salary) as min_salary from salaries
group by emp_no ) as mi,
(select emp_no,max(salary) as max_salary from salaries
where to_date = '9999-01-01'
group by emp_no) as ma
where mi.emp_no = ma.emp_no
order by growth;
