case when sum(a.e_11)=0 or sum(a.c_11)=0 or sum(b.c_55*a.c_11)=0 then 0 else round(((sum(b.e_55*a.e_11)/sum(a.e_11)-sum(b.c_55*a.c_11)/ sum(a.c_11))/ sum(b.c_55*a.c_11)/ sum(a.c_11),4)+1)*100 end k
缺失右括号 怎么回事?谢谢各位大神 求帮助
...全文
2674打赏收藏
缺失右括号
case when sum(a.e_11)=0 or sum(a.c_11)=0 or sum(b.c_55*a.c_11)=0 then 0 else round(((sum(b.e_55*a.e_11)/sum(a.e_11)-sum(b.c_55*a.c_11)/ sum(a.c_11))/ sum(b.c_55*a.c_11)/ sum(a.c_11),4)+1)*100 end k 缺失右括号 怎么回事?谢谢各位大神 求帮助
case
when sum(a.e_11)=0 or sum(a.c_11)=0 or sum(b.c_55*a.c_11)=0
then 0
else (
round(
(sum(b.e_55*a.e_11)/sum(a.e_11)-sum(b.c_55*a.c_11)/ sum(a.c_11))/ sum(b.c_55*a.c_11)/ sum(a.c_11),4
)+1
)*100
end k
你是取小数点后的4位