Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE test2 (date_col date, cus int, cus_sum int);
- insert into test2 values ('2018-01-01', 1, 5);
- insert into test2 values ('2018-01-02', 1, 12);
- insert into test2 values ('2018-01-02', 2, 14);
- insert into test2 values ('2018-01-03', 2, 8);
- insert into test2 values ('2018-01-03', 2, 10);
- insert into test2 values ('2018-01-04', 1, 22);
- insert into test2 values ('2018-01-06', 2, 20);
- insert into test2 values ('2018-01-06', 1, 5);
- insert into test2 values ('2018-01-07', 1, 45);
- insert into test2 values ('2018-01-08', 2, 32);
- date_col cus cum_sum
- "2018-01-01" 1 5
- "2018-01-01" 2 0
- "2018-01-02" 1 17
- "2018-01-02" 2 14
- "2018-01-03" 1 17
- "2018-01-03" 2 32
- "2018-01-04" 1 39
- "2018-01-04" 2 32
- "2018-01-05" 1 39
- "2018-01-05" 2 32
- "2018-01-06" 1 89
- "2018-01-06" 2 52
- "2018-01-07" 1 134
- "2018-01-07" 2 52
- "2018-01-08" 1 134
- "2018-01-08" 1 84
Add Comment
Please, Sign In to add comment