oracle报错00936 缺失表达式 错误 select t.comcode 组代码,(select y.comcname from cc_company y where y.comcode=t.comcode) 组名称,sum(decode(aa.a3,0,aa.a1,0)) as 零分总量,sum(decode(aa.a3,1,aa.a1,0)) as 一分总量,sum(decode(aa.a3,2
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/29 09:21:51
![oracle报错00936 缺失表达式 错误 select t.comcode 组代码,(select y.comcname from cc_company y where y.comcode=t.comcode) 组名称,sum(decode(aa.a3,0,aa.a1,0)) as 零分总量,sum(decode(aa.a3,1,aa.a1,0)) as 一分总量,sum(decode(aa.a3,2](/uploads/image/z/8307518-14-8.jpg?t=oracle%E6%8A%A5%E9%94%9900936+%E7%BC%BA%E5%A4%B1%E8%A1%A8%E8%BE%BE%E5%BC%8F+%E9%94%99%E8%AF%AF+select+t.comcode+%E7%BB%84%E4%BB%A3%E7%A0%81%2C%28select+y.comcname+from+cc_company+y+where+y.comcode%3Dt.comcode%29+%E7%BB%84%E5%90%8D%E7%A7%B0%2Csum%28decode%28aa.a3%2C0%2Caa.a1%2C0%29%29+as+%E9%9B%B6%E5%88%86%E6%80%BB%E9%87%8F%2Csum%28decode%28aa.a3%2C1%2Caa.a1%2C0%29%29+as+%E4%B8%80%E5%88%86%E6%80%BB%E9%87%8F%2Csum%28decode%28aa.a3%2C2)
xn@_en*dkTk{"9|RU>J"$Zʇ.J>MouDH%?kn] 76V xb~pc2XΎOˏO4fC0påv!zB&