select a.emp_no,max(salary)-min(salary) growth
from employees a
left join salaries b on a.emp_no=b.emp_no
group by a.emp_no having max(to_date)='9999-01-01'
select a.emp_no,max(salary)-min(salary) growth
from employees a
left join salaries b on a.emp_no=b.emp_no
group by a.emp_no having max(to_date)='9999-01-01'
牛客博客，记录你的成长
京公网安备 11010502036488号