WITH T AS (
SELECT 'AAA' AS Y2013, '10%' AS Y2014, '111' AS Y2015, 'A' AS Y2016 FROM DUAL
UNION ALL SELECT 'BBB' , '20%', '222', 'B' FROM DUAL
UNION ALL SELECT 'CCC' , '30%', '333', 'C' FROM DUAL
)
SELECT * FROM T;
이부분을 pivot을 써서 아래처럼 변경하고 싶은데 방법을 문의드립니다
몇시간을 헤맷지만 쉽게 되질 않네요ㅜ
고수님들의 고견을 여쭙습니다 꾸벅~
------------------------------------------
Y2013 : AAA BBB CCC
Y2014 :10% 20% 30%
Y2015 :111 222 333
Y2016 : A B C