拥有数据库,如果每个员工的工资每6个月增加一次,则根据职位的以下费率计算每个员工的当前工资
也许是这样的(使用sql server,你不会谈论你的数据库引擎……没有测试(
select
*,
case when datediff(month, date_start, getdate()) < 6
or position not in ('data analys intern','accountant','marketing manager','support specialist')
then base_salary
else
base_salary * datediff(month, date_start, getdate()) % 6
case position
when 'data analys intern' then 1.8
when 'accountant' then 1.3
when 'marketing manager' then 1.5
when 'support specialist' then 1.6
end
end as newSalary
from your_database