FROM (SELECT B.VDR_CD AS VDR_CD,
B.COD_STTL_CLS_DT AS COD_STTL_CLS_DT,
C.DLVR_PHY_DTRBT_DIV AS DLVR_PHY_DTRBT_DIV,
COUNT(*) AS OBJECT_X_COUNT,
SUM(NVL(B.TXIN_DCNT_TL_AMT,0) + NVL(B.TXIN_CRRG_FEE_DCNT_TL_AMT,0)) AS DIV_ONE_AMT,
SUM(NVL(B.PRDCNT_TXIN_SALITM_PRC_TL_AMT,0)) AS PRDCNT_TXIN_SALITM_PRC_TL_AMT,
SUM(NVL(B.PRDCNT_TXIN_CRRG_FEE_TL_AMT,0)) AS PRDCNT_TXIN_CRRG_FEE_TL_AMT,
SUM(NVL(B.TXIN_WG_TL_AMT,0)) AS COD_STTL_WG_TL_PLS_AMT
B.COD_STTL_CLS_DT AS COD_STTL_CLS_DT,
C.DLVR_PHY_DTRBT_DIV AS DLVR_PHY_DTRBT_DIV,
COUNT(*) AS OBJECT_X_COUNT,
SUM(NVL(B.TXIN_DCNT_TL_AMT,0) + NVL(B.TXIN_CRRG_FEE_DCNT_TL_AMT,0)) AS DIV_ONE_AMT,
SUM(NVL(B.PRDCNT_TXIN_SALITM_PRC_TL_AMT,0)) AS PRDCNT_TXIN_SALITM_PRC_TL_AMT,
SUM(NVL(B.PRDCNT_TXIN_CRRG_FEE_TL_AMT,0)) AS PRDCNT_TXIN_CRRG_FEE_TL_AMT,
SUM(NVL(B.TXIN_WG_TL_AMT,0)) AS COD_STTL_WG_TL_PLS_AMT
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货