본문 바로가기

IT 낙서장

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;

'IT 낙서장' 카테고리의 다른 글

jstl을 쓰려면  (0) 2014.01.24
자바 웹 프로젝트 간략하게 만들기  (0) 2014.01.24
오라클 행 열 바꾸는거 decode max 안쓰고  (0) 2014.01.24
오라클 함수 목록  (0) 2014.01.24
행열 바꾸는 오라클 로직  (0) 2014.01.24