Guest User

Untitled

a guest
Jul 19th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. CREATE TABLE test2 (date_col date, cus int, cus_sum int);
  2. insert into test2 values ('2018-01-01', 1, 5);
  3. insert into test2 values ('2018-01-02', 1, 12);
  4. insert into test2 values ('2018-01-02', 2, 14);
  5. insert into test2 values ('2018-01-03', 2, 8);
  6. insert into test2 values ('2018-01-03', 2, 10);
  7. insert into test2 values ('2018-01-04', 1, 22);
  8. insert into test2 values ('2018-01-06', 2, 20);
  9. insert into test2 values ('2018-01-06', 1, 5);
  10. insert into test2 values ('2018-01-07', 1, 45);
  11. insert into test2 values ('2018-01-08', 2, 32);
  12.  
  13. date_col cus cum_sum
  14. "2018-01-01" 1 5
  15. "2018-01-01" 2 0
  16. "2018-01-02" 1 17
  17. "2018-01-02" 2 14
  18. "2018-01-03" 1 17
  19. "2018-01-03" 2 32
  20. "2018-01-04" 1 39
  21. "2018-01-04" 2 32
  22. "2018-01-05" 1 39
  23. "2018-01-05" 2 32
  24. "2018-01-06" 1 89
  25. "2018-01-06" 2 52
  26. "2018-01-07" 1 134
  27. "2018-01-07" 2 52
  28. "2018-01-08" 1 134
  29. "2018-01-08" 1 84
Add Comment
Please, Sign In to add comment