ORCAL 查询报错:“not a single-group group function ”SELECT NC56.BD_COSTSUBJ.COSTNAME,NC56.BD_COSTSUBJ.COSTCODE,NC56.BD_CORP.UNITNAME,SUM(ARAP_DJFB.DFYBJE+ ARAP_DJFB.JFYBJE) AS BYSH ,ARAP_DJZB.SHRQ,To_Number(SubStr(ARAP_DJZB.SHRQ ,1 ,4)),To_N
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/28 13:49:17
![ORCAL 查询报错:“not a single-group group function ”SELECT NC56.BD_COSTSUBJ.COSTNAME,NC56.BD_COSTSUBJ.COSTCODE,NC56.BD_CORP.UNITNAME,SUM(ARAP_DJFB.DFYBJE+ ARAP_DJFB.JFYBJE) AS BYSH ,ARAP_DJZB.SHRQ,To_Number(SubStr(ARAP_DJZB.SHRQ ,1 ,4)),To_N](/uploads/image/z/13653435-3-5.jpg?t=ORCAL+%E6%9F%A5%E8%AF%A2%E6%8A%A5%E9%94%99%EF%BC%9A%E2%80%9Cnot+a+single-group+group+function+%E2%80%9DSELECT+NC56.BD_COSTSUBJ.COSTNAME%2CNC56.BD_COSTSUBJ.COSTCODE%2CNC56.BD_CORP.UNITNAME%2CSUM%28ARAP_DJFB.DFYBJE%2B+ARAP_DJFB.JFYBJE%29+AS+BYSH+%2CARAP_DJZB.SHRQ%2CTo_Number%28SubStr%28ARAP_DJZB.SHRQ+%2C1+%2C4%29%29%2CTo_N)
ORCAL 查询报错:“not a single-group group function ”SELECT NC56.BD_COSTSUBJ.COSTNAME,NC56.BD_COSTSUBJ.COSTCODE,NC56.BD_CORP.UNITNAME,SUM(ARAP_DJFB.DFYBJE+ ARAP_DJFB.JFYBJE) AS BYSH ,ARAP_DJZB.SHRQ,To_Number(SubStr(ARAP_DJZB.SHRQ ,1 ,4)),To_N
ORCAL 查询报错:“not a single-group group function ”
SELECT NC56.BD_COSTSUBJ.COSTNAME,NC56.BD_COSTSUBJ.COSTCODE,NC56.BD_CORP.UNITNAME,SUM(ARAP_DJFB.DFYBJE+ ARAP_DJFB.JFYBJE) AS BYSH ,ARAP_DJZB.SHRQ,To_Number(SubStr(ARAP_DJZB.SHRQ ,1 ,4)),To_Number(SubStr(ARAP_DJZB.SHRQ ,6 ,2)),NC56.BD_DEFDOC.DOCNAME FROM NC56.BD_COSTSUBJ,NC56.BD_CORP,ARAP_DJFB,ARAP_DJZB,NC56.BD_DEFDOC WHERE COSTCODE LIKE '209' || '%' AND UNITNAME='华康保险代理有限公司广东分公司' AND To_Number(SubStr(ARAP_DJZB.SHRQ ,1 ,4)) = 2011 AND DOCNAME='代理人渠道' AND To_Number(SubStr(ARAP_DJZB.SHRQ ,6 ,2))=2
ORDER BY NC56.BD_COSTSUBJ.COSTNAME
查询报错:“not a single-group group function ”
ORCAL 查询报错:“not a single-group group function ”SELECT NC56.BD_COSTSUBJ.COSTNAME,NC56.BD_COSTSUBJ.COSTCODE,NC56.BD_CORP.UNITNAME,SUM(ARAP_DJFB.DFYBJE+ ARAP_DJFB.JFYBJE) AS BYSH ,ARAP_DJZB.SHRQ,To_Number(SubStr(ARAP_DJZB.SHRQ ,1 ,4)),To_N
SUM(ARAP_DJFB.DFYBJE+ ARAP_DJFB.JFYBJE) AS BYSH ,需要有group by