--查询

select round(sum(gjdj00*cksl00),2),sum(round(gjdj00*cksl00,2)) from (
select X.CKDH00,X.YFBMBH,X.CKBMBH,X.CKBMMC,X.CKLXBH,X.CKLXMC,X.CZY000,X.CZYXM0,
X.QRR000,X.QRRXM0,X.SRRQ00,X.SRSJ00,X.QRRQ00,X.QRSJ00,X.CKZT00,X.YPCKPC,
X.YPNM00,X.YPBM00,X.YPMC00,X.YPGG00,X.GJDJ00,X.LSDJ00,X.PFDJ00,X.CKSL00,
X.CKDW00,X.ZHL000,X.CXBZ00,X.CXCKPC,X.PYSM00,X.WBSM00,X.BZ0000,X.YPMLBZ,
X.TKRKDH,X.FHR000 from VW_YF_YPCKCX X,BM_YD0000 D
WHERE X.YFBMBH=480 AND X.QRRQ00>='20230527' AND X.QRRQ00<='20230527' AND X.YPNM00=D.YPNM00 and x.ckdh00='219504'
)
ORDER BY CKBMMC,CKLXMC --6416.03
--------------

--打印：
select sum(gjje00) from (
SELECT D.QRRQ00,D.RKDH00,D.ZKJE00,
X.FPH000,X.YPMC00,X.YPGG00,X.RKDW00,X.RKSL00,nvl(X.YGJDJ0,X.FPGJDJ) FPGJDJ,
X.KL0000,x.ygjdj0,x.gjdj00,NVL(X.YGJDJ0*X.RKSL00,X.GJJE00) GJJE00,(X.YGJDJ0*X.RKSL00) ygjje0,X.LSDJ00,H.BMMC00 as CRBMMC,
ROUND(X.RKSL00*X.LSDJ00,2) AS LSJE00,
ROUND(ROUND(X.RKSL00*X.LSDJ00,2)-NVL(X.YGJDJ0*X.RKSL00,X.GJJE00),2) AS JXCJ00
FROM YK_YPRKMX X,YK_YPRKD0 D,BM_BMBM00 H
WHERE X.RKDH00=D.RKDH00 AND D.YKBMBH=H.BMBH00
AND X.RKDH00='019921'
)--sum(gjje00)=6416.025