select A.*
from (
select 1 day, 'a' apno, 10 cost, 1 qty from dual
union
select 2, 'a', 10, 2 qty from dual
union
select 3, 'a', 10 , 3 qty from dual
union
select 4, 'a', 10, 4 qty from dual
union
select 5, 'a', 10, 5 qty from dual
union
select 10, 'a', 12, 6 qty from dual
union
select 11, 'a', 12, 7 qty from dual
union
select 20, 'a', 10, 8 qty from dual
union
select 30, 'a', 10, 9 qty from dual
) A
order by day
금액이 변경된데 부터까지 누적합계를 구하고 싶습니다.
날짜 |
금액 |
합계 |
5일 |
10 |
150 |
7일 |
12 |
156 |
30일 |
10 |
170 |
부탁드립니다.
|