美文网首页
个人所得税

个人所得税

作者: ILYBYLM | 来源:发表于2018-11-11 19:28 被阅读0次

update copy_emp1,(
select sal,CASE
when sal>5000 and sal <= 8000 then (sal-5000)0.03
when sal>8000 and sal<= 17000 then (sal-5000)
0.1-90
when sal>17000 and sal <=30000 then (sal-5000)0.2-990
when sal>30000 and sal <=40000 then (sal-5000)
0.25-3590
else 0 end tax from copy_emp1) taxtable set copy_emp1.sal=taxtable.tax where copy_emp1.sal=taxtable.sal;

难点

相关文章

网友评论

      本文标题:个人所得税

      本文链接:https://www.haomeiwen.com/subject/rlkffqtx.html