累计税计算

zhangxiaoqqi · zhangxiaoqqi · commit 30b7c78808bb · 2017-07-17T14:42:38.000+08:00
diff --git a/mysql开发技巧三/如何计算累进税 b/mysql开发技巧三/如何计算累进税
@@ -0,0 +1,10 @@
+计算累进税类问题
+使用least（）实现计算不同区间个人所得税：
+select user_name,sum(curmoney*rate)as taxmoney
+from(
+select user_name,money,low,high,
+least(money-low,high-low) as curmoney,rate
+from user1 a join taxrate b
+on a.money>b.low
+) a
+group by user_name
