为以防一年内员工多次涨薪,以下查询代码更保守
select
s1.emp_no
,max(s2.from_date)
,sum(s2.salary-s1.salary) salary_growth
from salaries s1
inner join salaries s2
on s1.emp_no = s2.emp_no
and s1.to_date = s2.from_date
where (s2.salary-s1.salary) > 5000
and
(
cast(strftime('%Y',s2.to_date) as signed int)
-
cast(strftime('%Y',s1.from_date) as signed int)
) <= 2
group by s1.emp_no
order by salary_growth desc
京公网安备 11010502036488号