Oracle - 순차적으로 누적하기3

[ Oracle - 순차적으로 누적하기3 ]

 

Date   Code Amt
20120701   1111 1000
20120701   1112  2000
20120702    data 없음
20120703    1111 3000
20120704    1112 5000
20120704    3333 1000
20120705 data 없음


결과: 20120705 기준 조회

Date   Code Amt
20120701    1111 1000
20120701    1112  2000

20120702    1111 1000
20120702    1112 2000

20120703    1111  4000
20120703    1112 2000

20120704    1111   4000
20120704    1112   7000
20120704    3333   1000

20120705    1111    4000
20120705    1112    7000
20120705    3333    1000
.
.
.

위와 같은 결과를 얻고 싶습니다. (1일 부터 해당일자 까지 누적 합계,  1, 1~2, 1~3, 1~4, 1~5일 이런식으로 한달치 누적합계)
특정일자에 data가 없으면 전날 까지의 누적 합계가  그 날짜의 합계가됨.

 

with tab as ( select '20120701' as date1, '1111' as code, 1000 as amt from dual union all select '20120701' as date1, '1112' as code, 2000 as amt from dual union all select '20120702' as date1, '' as code, 0 as amt from dual union all select '20120703' as date1, '1111' as code, 3000 as amt from dual union all select '20120704' as date1, '1112' as code, 5000 as amt from dual union all select '20120704' as date1, '3333' as code, 1000 as amt from dual union all select '20120705' as date1, '' as code, 0 as amt from dual ) select t2.date1 "Date" , t1.code "Code" , sum(distinct t1.amt) "Amt" from tab t1, tab t2 where t1.date1 <= t2.date1 and t1.code is not null group by t2.date1, t1.code order by t2.date1, t1.code;