SELECT CASE WHEN CD = 10 THEN CNT END AS CD_10,

CASE WHEN CD = 20 THEN CNT END AS CD_20,

CASE WHEN CD = 30 THEN CNT END AS CD_30

FROM T

GROUP BY DT

코드의 수가 고정이라고하면 이런식으로 쭉적으시면되요....

with t as (
SELECT '2011-11' AS DT, 10 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-11' AS DT, 20 AS CD, 10 AS CNT FROM DUAL UNION ALL
SELECT '2011-11' AS DT, 30 AS CD, 2 AS CNT FROM DUAL UNION ALL
SELECT '2011-11' AS DT, 40 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-11' AS DT, 50 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-11' AS DT, 60 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-11' AS DT, 70 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-11' AS DT, 80 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-11' AS DT, 90 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-11' AS DT, 91 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 10 AS CD, 21 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 20 AS CD, 30 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 30 AS CD, 5 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 40 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 50 AS CD, 10 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 60 AS CD, 4 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 70 AS CD, 8 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 80 AS CD, 0 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 90 AS CD, 2 AS CNT FROM DUAL UNION ALL
SELECT '2011-10' AS DT, 91 AS CD, 0 AS CNT FROM DUAL
)
SELECT DT,
       MIN(DECODE(CD, 10, CNT)) AS "10",
       MIN(DECODE(CD, 20, CNT)) AS "20",
       MIN(DECODE(CD, 30, CNT)) AS "30",
       MIN(DECODE(CD, 40, CNT)) AS "40",
       MIN(DECODE(CD, 50, CNT)) AS "50",
       MIN(DECODE(CD, 60, CNT)) AS "60",
       MIN(DECODE(CD, 70, CNT)) AS "70",
       MIN(DECODE(CD, 80, CNT)) AS "80",
       MIN(DECODE(CD, 90, CNT)) AS "90",
       MIN(DECODE(CD, 91, CNT)) AS "91"
FROM t
GROUP BY DT

이런식이 어떤지... CD가 정해져 있다면 이렇게 하면됩니다. 더 좋은 방법 있으면 저도 좀 알려주세요^^*

select DT ,

           sum(decode(CD, '10', CNT, 0)) as "10",

           sum(decode(CD, '20', CNT, 0)) as "20",

           sum(decode(CD, '30', CNT, 0)) as "30",

                                . . .

           sum(decode(CD, '91', CNT, 0) as "91"

from t

group by DT;

이렇게 해도 ...괜찮지 않을까요...test해볼수 없어서 못해보고 올려요