▲求按金额分类计费的SQL▲

Question

select sum(decode(sign(amount-10000),-1,5,decode(sign(amount-50000),-1,amount*0.0003,decode(sign(amount-100000),-1,amount*0.0002,20)))) from tbname;

Answer 1

select (case when amount<10000 then 5 
        when amount<50000 and amount>10000 then amount*0.03/100
        when amount<100000 and amount>50000 then amount*0.02/100
        else 20
        end) fee
from table