안녕하세요;; 행 합치기는 많이 보아왔는데 열합치기는 어떻게 해야할지 감이 안오네요...
2014-06-09 Android Eclair(Android O/S 2.1) 1 0 0 1
2014-06-09 Android Donut(Android O/S 1.6) 0 0 0 0
2014-04-11 Android Donut(Android O/S 1.6) 1 0 0 0
2014-04-07 Android Froyo(Android O/S 2.2) 1 0 0 0
2014-04-07 Android Eclair(Android O/S 2.1) 1 0 0 0
아래 처럼 뽑아보려고 합니다;;
2014-06-09 1 0 0 1
2014-04-11 1 0 0 0
2014-04-07 2 0 0 0
with t as(
select '2014-06-09' as dt, '1' as d1, '0' as d2, '0' as d3, '1' as d4 from dual
union all select '2014-06-09' as dt, '0' as d1, '0' as d2, '0' as d3, '0' as d4 from dual
union all select '2014-04-11' as dt, '1' as d1, '0' as d2, '0' as d3, '0' as d4 from dual
union all select '2014-04-07' as dt, '1' as d1, '0' as d2, '0' as d3, '0' as d4 from dual
union all select '2014-04-07' as dt, '1' as d1, '0' as d2, '0' as d3, '0' as d4 from dual
)
select dt,sum(d1),sum(d2),sum(d3),sum(d4)
from t
group by dt