728x90
반응형
SMALL
GROUP BY
-
[ORACLE] 한꺼번에 집어넣기 - GROUP BY AND MAX 이용혼자서 공부하기/SQL 2008. 4. 28. 17:08
SELECT MAX(C.STR_CODE) AS STR_CODE ,MAX(C.ITM_CODE) AS ITM_CODE ,C.PAY_YMD AS PAY_YMD ,SUM(C.TEMP) AS TEMP ,SUM(C.TEMP1) AS TEMP1 ,SUM(C.TEMP2) AS TEMP2 ,(SUM(C.TEMP) - SUM(C.TEMP1) + SUM(C.TEMP2)) AS TEMP3 FROM (SELECT MAX(STR_CODE) AS STR_CODE ,MAX(ITM_CODE) AS ITM_CODE ,PAY_YMD AS PAY_YMD ,PAY_FLAG AS PAY_FLAG ,QTY AS QTY ,DECODE(PAY_FLAG, '01', QTY, 0) AS TEMP ,DECODE(PAY_FLAG, '02', QTY, 0)..