[SQL] 통계관련 DECODE (COUNT, SUM)

SELECT COUNT(DECODE(PT_STT,'06',0)) as prcsCnt // PT_STT가 06인 COUNT ,NVL(SUM(DECODE(PT_STT,'06',HPE_AMT)),0) as prcsAmt // PT_STT가 06인 HPE_AMT의 합 ,COUNT(DECODE(PT_STT,'05',0)) as preCnt ,NVL(SUM(DECODE(PT_STT,'05',HPE_AMT)),0) as preAmt ,COUNT(DECODE(PT_STT,'11',0)) as endCnt ,NVL(SUM(DECODE(PT_STT,'11',HPE_AMT)),0) as endAmt FROM TESTAAA...