|
안녕하세요.. 쿼리 두문장이 있는데..
1과 2 문장에서 결과값이 다르게 나오는데 필드는 그대로 유지한상태로
1의 결과값이 나오게 해야합니다..방법이 있을까요..?
좋은하루 보내세요...
1)결과값 32,928
SELECT a.deshcd,
a.desedt,
a.deposn,
a.decrus,
c.gomidd,
ROUND(SUM(DECODE(c.gotxkn,'1',DECODE(a.desegb,'0',((b.COOTAM-(b.COOTAM/1.1))*b.COUNIT)*a.deseqt,
((b.COOTAM-(b.COOTAM/1.1))*b.COUNIT)*a.deseqt * -1),0))) AS puvat2
FROM SCDESETB a,
SCCOMBTB b,
SCGOODTB c
WHERE a.deshcd = :pis_shcd
AND a.desedt = :pis_date
AND a.desegb IN ('0','1')
AND a.decomb = '1'
AND b.coshcd = a.deshcd
AND b.cocmcd = a.degocd
AND c.goshcd = b.coshcd
AND b.codeyn = 'N'
AND c.gogocd = b.cogocd
GROUP BY a.deshcd,
a.desedt,
a.deposn,
a.decrus,
c.gomidd
2) 결과값 32,925
SELECT a.deshcd,
a.desedt,
c.gogocd,
a.demakn,
a.desehh,
ROUND(SUM(DECODE(c.gotxkn,'1',DECODE(a.desegb,'0',((b.COOTAM-(b.COOTAM/1.1))*b.COUNIT)*a.deseqt,
((b.COOTAM-(b.COOTAM/1.1))*b.COUNIT)*a.deseqt * -1),0))) AS puvat2
FROM SCDESETB a,
SCCOMBTB b,
SCGOODTB c
WHERE a.deshcd = :pis_shcd
AND a.desedt = :pis_date
AND a.desegb IN ('0','1')
AND a.decomb = '1'
AND b.coshcd = a.deshcd
AND b.cocmcd = a.degocd
AND c.goshcd = b.coshcd
AND b.codeyn = 'N'
AND c.gogocd = b.cogocd
GROUP BY a.deshcd,
a.desedt,
c.gogocd,
a.demakn,
a.desehh |
