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 '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;
'IT 낙서장' 카테고리의 다른 글
jstl을 쓰려면 (0) | 2014.01.24 |
---|---|
자바 웹 프로젝트 간략하게 만들기 (0) | 2014.01.24 |
오라클 행 열 바꾸는거 decode max 안쓰고 (0) | 2014.01.24 |
오라클 함수 목록 (0) | 2014.01.24 |
행열 바꾸는 오라클 로직 (0) | 2014.01.24 |