with tb as
(
select '20110211' dt, 1 cnt, 'WL01003' id from dual union all
select '20110211' dt, 3 cnt, 'WL02003' id from dual union all
select '20110211' dt, 2 cnt, 'WL01003' id from dual union all
select '20110211' dt, 3 cnt, 'WL02003' id from dual union all
select '20110212' dt, 1 cnt, 'WL03003' id from dual union all
select '20110212' dt, 0 cnt, 'WL03003' id from dual union all
select '20110214' dt, 3 cnt, 'WL01003' id from dual
)
select dt
, nvl(sum(decode(id,'WL01003',cnt)),0) as WL01003
, nvl(sum(decode(id,'WL02003',cnt)),0) as WL02003
, nvl(sum(decode(id,'WL03003',cnt)),0) as WL03003
from tb
group by dt
order by dt
;

답변 감사합니다..^^

ID 컬럼의 데이타 값이 가변적일 경우 동적쿼리로 작성하셔야 합니다.