ORCAL 查询报错:“not a single-group group function ”
来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/07/14 18:07:55
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 ”
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 ”
SUM(ARAP_DJFB.DFYBJE+ ARAP_DJFB.JFYBJE) AS BYSH ,需要有group by
ORCAL 查询报错:“not a single-group group function ”
有关group by报错,not a GOUP BY expression
group:
group
define subscreen for function group - how to?
英语翻译combine each group of sentences into a single sentence,u
英语翻译It has taken hold in a way that fits no single age group
连词成句规则combine each group of sentences into a single setence,
连句成句规则combine each group of sentences into a single setence,
SQL2005 报错 在关键字'group' 附近有语法错误
you are not a member of the administrator group是什么意思
in a group