要求:判断结果是否大于0.01,大于0.01保留两位小数,小于0.01保留五位小数
(case when round(sum(nvl(b.plan_eq,0))/100000000,2)< 0.01 THEN round (sum(nvl(b.plan_eq,0))/100000000,5) else round(sum(nvl(b.plan_eq,0))/100000000,2) end ) foreaast
要求:判断结果是否大于0.01,大于0.01保留两位小数,小于0.01保留五位小数
(case when round(sum(nvl(b.plan_eq,0))/100000000,2)< 0.01 THEN round (sum(nvl(b.plan_eq,0))/100000000,5) else round(sum(nvl(b.plan_eq,0))/100000000,2) end ) foreaast