decode 없이 오라클 행 열 바꾸기2
카테고리 없음2015. 2. 14. 20:23
반응형
decode 없이 오라클 행 열 바꾸기2
WITH DATA1 AS (
SELECT '01' AS MM, 100 AS QTY, 200 AS AMT FROM DUAL UNION ALL
SELECT '02' AS MM, 100 AS QTY, 200 AS AMT FROM DUAL UNION ALL
SELECT '03' AS MM, 100 AS QTY, 200 AS AMT FROM DUAL UNION ALL
SELECT '10' AS MM, 100 AS QTY, 200 AS AMT FROM DUAL
)
SELECT *
FROM (
SELECT *
FROM DATA1
) PIVOT (
SUM(QTY) AS QTY,
SUM(AMT) AS AMT
FOR
MM IN ( '01' AS "MM1", '02' AS "MM2", '03' AS "MM3", '10' AS "MM10")
);(1101,1102,1103,1104,1105))
order by Character;
반응형
