By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
14 rows affected
Pid | Id | Date | IN | OUT | Balance |
---|---|---|---|---|---|
1 | 3345312 | 2022-08-07 | 100 | 50 | 250 |
1 | 5435245 | 2022-08-06 | 50 | 50 | 200 |
1 | 4353451 | 2022-08-05 | 0 | 100 | 200 |
1 | 5762454 | 2022-08-04 | 20 | 100 | 300 |
1 | 7634523 | 2022-08-03 | 400 | 100 | 380 |
1 | 5623456 | 2022-08-02 | 100 | 20 | 80 |
1 | 4524354 | 2022-08-01 | 0 | 0 | 0 |
2 | 1234567 | 2022-08-07 | 20 | 10 | 150 |
2 | 1234568 | 2022-08-06 | 5 | 5 | 140 |
2 | 1234569 | 2022-08-05 | 0 | 30 | 140 |
2 | 1234570 | 2022-08-04 | 10 | 20 | 170 |
2 | 1234571 | 2022-08-03 | 200 | 50 | 180 |
2 | 1234572 | 2022-08-02 | 50 | 20 | 30 |
2 | 1234573 | 2022-08-01 | 0 | 0 | 0 |
Pid | Id | Date | IN | OUT | Balance |
---|---|---|---|---|---|
1 | 3345312 | 2022-08-07 | 100 | 50 | 330 |
1 | 5435245 | 2022-08-06 | 50 | 50 | 280 |
1 | 4353451 | 2022-08-05 | 0 | 100 | 280 |
1 | 5762454 | 2022-08-04 | 100 | 100 | 380 |
1 | 7634523 | 2022-08-03 | 400 | 100 | null |
1 | 5623456 | 2022-08-02 | 100 | 20 | null |
1 | 4524354 | 2022-08-01 | 0 | 0 | null |
2 | 1234567 | 2022-08-07 | 20 | 10 | null |
2 | 1234568 | 2022-08-06 | 5 | 5 | null |
2 | 1234569 | 2022-08-05 | 0 | 30 | null |
2 | 1234570 | 2022-08-04 | 10 | 20 | null |
2 | 1234571 | 2022-08-03 | 200 | 50 | null |
2 | 1234572 | 2022-08-02 | 50 | 20 | null |
2 | 1234573 | 2022-08-01 | 0 | 0 | null |