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/04/29 12:57:10
ORCAL查询报错:“notasingle-groupgroupfunction”SELECTNC56.BD_COSTSUBJ.COSTNAME,NC56.BD_COSTSUBJ.COSTCODE,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