总提示ORA-00979:不是GROUP BY 表达式，可以已经做分组了

2020-07-06 11:45:15 1.4k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【Cadence】 ADS Dynamic Link使用教程在Cadence617上使用ADS Dynamic Link 阅读详情

查询语句如下，
SELECT B.SPCODE SPCODE,
B.BARCODE BARCODE,
B.NAME NAME,
C.FDBH FDBH,
sum(C.XSJE) XSJE,sum(C.XSSL) XSSL,
(SELECT SUM(P.JHSL*P.JHDJ)/SUM(P.JHSL) from SPFPCJC P,KCPCXX K WHERE P.KCPCH=K.KCPCH AND P.SP_ID=C.SP_ID AND TRUNC(K.JHSJ)>=TO_DATE('2020.01.01') AND TRUNC(K.JHSJ)<=TO_DATE('2020.01.31')) JHCB

FROM SKTXSJL L,
SKTXSJLC C,
SKTXSJLM M,
SPXX_JB B
WHERE ( L.SKTNO = C.SKTNO ) and
( L.SKTNO = M.SKTNO ) and
( C.SP_ID = B.SP_ID ) and
( L.JLBH = C.JLBH ) and
( L.JLBH = M.JLBH ) and
( ( M.SKFS = 29 ) AND
( trunc(L.JYSJ) >= '2020.01.01' AND TRUNC(L.JYSJ)<='2020.01.31') )
GROUP BY B.SPCODE,
B.BARCODE,
B.NAME,
C.FDBH;

...全文

2025虚幻游戏逆向工程解包尝试 2025虚幻游戏逆向工程解包指南本文详细介绍了虚幻引擎5游戏逆向解包的完整流程，主要包括获取AES密钥、生成映射文件和导出资源三个关键步骤。作者在实际操作中遇到诸多难题：AES密钥获取工具存在加壳保护问题，映射文件生成器依赖复杂的VS编译环境，DLL注入工具的使用也存在技术门槛。通过多次尝试，作者发现部分游戏可直接搜索现成的AES密钥，而映射文件生成需要额外下载Memcury依赖库才能正常编译。文章提供了相关工具的下载链接和具体操作说明，但同时也指出每个环节都可能出现意外状况，逆向工程实际执行过程远比理论阅读详情

嘉友云阁

基础和管理 17,379 成员 95,111 内容

+ 关注 + 加入社区

切换为时间正序

nayi_224 2020-07-08

打赏
举报

标量子查询直接进行聚合，这时group的语法会变得非常奇怪，不建议去研究这种冷门的东西。要么把标量子查询改写，要么外面再套一层。

wildwolv 2020-07-06

打赏
举报

wildwolv 2020-07-06

打赏
举报

SELECT B.SPCODE SPCODE, B.BARCODE BARCODE, B.NAME NAME, C.FDBH FDBH, sum(C.XSJE) XSJE,sum(C.XSSL) XSSL, A.JHCB FROM SKTXSJL L, SKTXSJLC C, SKTXSJLM M, SPXX_JB B， (SELECT SUM(P.JHSL*P.JHDJ)/SUM(P.JHSL) as JHCB from SPFPCJC P,KCPCXX K WHERE P.KCPCH=K.KCPCH AND P.SP_ID=C.SP_ID AND TRUNC(K.JHSJ)>=TO_DATE('2020.01.01') AND TRUNC(K.JHSJ)<=TO_DATE('2020.01.31')) A WHERE ( L.SKTNO = C.SKTNO ) and ( L.SKTNO = M.SKTNO ) and ( C.SP_ID = B.SP_ID ) and ( L.JLBH = C.JLBH ) and ( L.JLBH = M.JLBH ) and ( ( M.SKFS = 29 ) AND ( trunc(L.JYSJ) >= '2020.01.01' AND TRUNC(L.JYSJ)<='2020.01.31') ) GROUP BY B.SPCODE, B.BARCODE, B.NAME, C.FDBH, A.JHCB; 还有你这种trunc(L.JYSJ)的写法不知道有没有问题，我一般都用to_.SPCODE SPCODE, B.BARCODE BARCODE, B.NAME NAME, C.FDBH FDBH, sum(C.XSJE) XSJE,sum(C.XSSL) XSSL, A.JHCB FROM SKTXSJL L, SKTXSJLC C, SKTXSJLM M, SPXX_JB B， (SELECT SUM(P.JHSL*P.JHDJ)/SUM(P.JHSL) as JHCB from SPFPCJC P,KCPCXX K WHERE P.KCPCH=K.KCPCH AND P.SP_ID=C.SP_ID AND TRUNC(K.JHSJ)>=TO_DATE('2020.01.01') AND TRUNC(K.JHSJ)<=TO_DATE('2020.01.31')) A WHERE ( L.SKTNO = C.SKTNO ) and ( L.SKTNO = M.SKTNO ) and ( C.SP_ID = B.SP_ID ) and ( L.JLBH = C.JLBH ) and ( L.JLBH = M.JLBH ) and ( ( M.SKFS = 29 ) AND ( trunc(L.JYSJ) >= '2020.01.01' AND TRUNC(L.JYSJ)<='2020.01.31') ) GROUP BY B.SPCODE, B.BARCODE, B.NAME, C.FDBH, A.JHCB; 还有你这种trunc(L.JYSJ)的写法不知道有没有问题，我一般都用to_char

riven2011 2020-07-06

打赏
举报

引用 5 楼 wildwolv 的回复:

SELECT B.SPCODE SPCODE,
B.BARCODE BARCODE,
B.NAME NAME,
C.FDBH FDBH,
sum(C.XSJE) XSJE,sum(C.XSSL) XSSL,
SUM(P.JHSL*P.JHDJ)/SUM(P.JHSL) as JHCB
FROM SKTXSJL L,
SKTXSJLC C,
SKTXSJLM M,
SPXX_JB B，
SPFPCJC P,
KCPCXX K
WHERE ( L.SKTNO = C.SKTNO ) and
( L.SKTNO = M.SKTNO ) and
( C.SP_ID = B.SP_ID ) and
( L.JLBH = C.JLBH ) and
( L.JLBH = M.JLBH ) and
( ( M.SKFS = 29 ) AND
( trunc(L.JYSJ) >= '2020.01.01' AND TRUNC(L.JYSJ)<='2020.01.31') )
and P.KCPCH=K.KCPCH
AND P.SP_ID=C.SP_ID
AND TRUNC(K.JHSJ)>=TO_DATE('2020.01.01')
AND TRUNC(K.JHSJ)<=TO_DATE('2020.01.31')
GROUP BY B.SPCODE,
B.BARCODE,
B.NAME,
C.FDBH;

要改成外连接，不然不等价

SELECT B.SPCODE SPCODE

      ,B.BARCODE BARCODE

      ,B.NAME NAME

      ,C.FDBH FDBH

      ,SUM(C.XSJE) XSJE

      ,SUM(C.XSSL) XSSL

      ,SUM(T.JHCB) JHCB



FROM   SKTXSJL L

      ,SKTXSJLC C

      ,SKTXSJLM M

      ,SPXX_JB B

      ,(SELECT SUM(P.JHSL * P.JHDJ) / SUM(P.JHSL) JHCB

              ,P.SP_ID

        FROM   SPFPCJC P

              ,KCPCXX K

        WHERE  P.KCPCH = K.KCPCH

               AND TRUNC(K.JHSJ) >= TO_DATE('2020.01.01')

               AND TRUNC(K.JHSJ) <= TO_DATE('2020.01.31')

        GROUP  BY P.SP_ID) T

WHERE  (L.SKTNO = C.SKTNO)

       AND (L.SKTNO = M.SKTNO)

       AND (C.SP_ID = B.SP_ID)

       AND (L.JLBH = C.JLBH)

       AND (L.JLBH = M.JLBH)

       AND

       ((M.SKFS = 29) AND (trunc(L.JYSJ) >= '2020.01.01' AND TRUNC(L.JYSJ) <= '2020.01.31'))

       AND (C.SP_ID = T.SP_ID(+))

GROUP  BY B.SPCODE

         ,B.BARCODE

         ,B.NAME

         ,C.FDBH;

wildwolv 2020-07-06

打赏
举报

SELECT B.SPCODE SPCODE, B.BARCODE BARCODE, B.NAME NAME, C.FDBH FDBH, sum(C.XSJE) XSJE,sum(C.XSSL) XSSL, SUM(P.JHSL*P.JHDJ)/SUM(P.JHSL) as JHCB FROM SKTXSJL L, SKTXSJLC C, SKTXSJLM M, SPXX_JB B， SPFPCJC P, KCPCXX K WHERE ( L.SKTNO = C.SKTNO ) and ( L.SKTNO = M.SKTNO ) and ( C.SP_ID = B.SP_ID ) and ( L.JLBH = C.JLBH ) and ( L.JLBH = M.JLBH ) and ( ( M.SKFS = 29 ) AND ( trunc(L.JYSJ) >= '2020.01.01' AND TRUNC(L.JYSJ)<='2020.01.31') ) and P.KCPCH=K.KCPCH AND P.SP_ID=C.SP_ID AND TRUNC(K.JHSJ)>=TO_DATE('2020.01.01') AND TRUNC(K.JHSJ)<=TO_DATE('2020.01.31') GROUP BY B.SPCODE, B.BARCODE, B.NAME, C.FDBH;

嘉友云阁 2020-07-06

打赏
举报

错了，是c.sp_id标识符无效

嘉友云阁 2020-07-06

打赏
举报

提示C.FDBH标识符无效

总提示ORA-00979:不是GROUP BY 表达式，可以已经做分组了

相关推荐