데이터베이스 질문과 답변
SELECT T1.giftNm AS giftNm
,T1.giftCnt AS giftCnt
,T2.winCnt AS winCnt
,T3.winCnt AS win1Cnt
FROM
(SELECT SCRATCH_GIFT_NM AS giftNm
,GIFT_READY_CNT AS giftCnt
FROM EVT_SCRATCH_GIFT )T1,
(SELECT B.GIFT_CD AS giftNm
,SUM(B.EVT_WIN_CNT) AS winCnt
FROM SUMMARY_SCRATCH B
GROUP BY B.GIFT_CD)T2,
(SELECT A.GIFT_CD AS giftNm
,SUM(A.EVT_WIN_CNT) AS winCnt
FROM SUMMARY_SCRATCH A
WHERE A.EVT_DT = 20180401
GROUP BY A.GIFT_CD)T3
WHERE T1.giftNm = T2.giftNm(+) AND T1.giftNm = T3.giftNm(+)
ORDER BY giftCnt
롤업해서 합계나오게하는방법좀
by 스티브1조
[2018.03.15 20:13:52]
퇴근합고싶습니다 도와주세요
by 마농
[2018.03.16 08:37:24]
SELECT a.scratch_gift_nm AS giftnm
, SUM(a.gift_ready_cnt) AS giftcnt
, SUM(b.wincnt ) AS wincnt
, SUM(b.win1cnt) AS win1cnt
FROM evt_scratch_gift a
, (SELECT gift_cd AS giftnm
, SUM(evt_win_cnt) AS wincnt
, SUM(DECODE(evt_dt, '20180401', evt_win_cnt)) AS win1cnt
FROM summary_scratch
GROUP BY gift_cd
) b
WHERE a.scratch_gift_nm = t2.giftnm(+)
GROUP BY ROLLUP(a.scratch_gift_nm)
ORDER BY giftcnt
;
) 버튼을 클릭하여 작성 하시면 됩니다.