ORCAL 查询报错:“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_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 ”
1个回答 分类:综合 2014-10-27

问题解答:

我来补答
SUM(ARAP_DJFB.DFYBJE+ ARAP_DJFB.JFYBJE) AS BYSH ,需要有group by
 
 
展开全文阅读
剩余:2000