公式实现起来其实是比较简单的, CASE WHEN gz_yg BETWEEN 0.01 AND 500 THEN gz_yg * 0.05 WHEN gz_yg BETWEEN 500.01 AND 2000 THEN gz_yg * 0.1 - 25 WHEN gz_yg BETWEEN 2000.01 AND 5000 THEN gz_yg * 0.15 - 125 WHEN gz_yg BETWEEN 5000.01 AND 20000 THEN gz_yg * 0.20 - 375 WHEN gz_yg BETWEEN 20000.01 AND 40000 THEN gz_yg * 0.25 - 1375 WHEN gz_yg BETWEEN 40000.01 AND 60000 THEN gz_yg * 0.30 - 3375 WHEN gz_yg BETWEEN 60000.01 AND 80000 THEN gz_yg * 0.35 - 6375 WHEN gz_yg BETWEEN 80000.01 AND 100000 THEN gz_yg * 0.40 - 10375 WHEN gz_yg >= 100000 THEN gz_yg * 0.45 - 15375 ELSE 0 END ,但是...,第一次做所以不太明白按惯例应该是用什么方法.
CASE
WHEN gz_yg BETWEEN 0.01 AND 500
THEN gz_yg * 0.05
WHEN gz_yg BETWEEN 500.01 AND 2000
THEN gz_yg * 0.1 - 25
WHEN gz_yg BETWEEN 2000.01 AND 5000
THEN gz_yg * 0.15 - 125
WHEN gz_yg BETWEEN 5000.01 AND 20000
THEN gz_yg * 0.20 - 375
WHEN gz_yg BETWEEN 20000.01 AND 40000
THEN gz_yg * 0.25 - 1375
WHEN gz_yg BETWEEN 40000.01 AND 60000
THEN gz_yg * 0.30 - 3375
WHEN gz_yg BETWEEN 60000.01 AND 80000
THEN gz_yg * 0.35 - 6375
WHEN gz_yg BETWEEN 80000.01 AND 100000
THEN gz_yg * 0.40 - 10375
WHEN gz_yg >= 100000
THEN gz_yg * 0.45 - 15375
ELSE 0
END
,但是...,第一次做所以不太明白按惯例应该是用什么方法.