By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
5.6.45 |
p_jobid | the_sum |
---|---|
1000 | 100.00 |
1001 | 50.00 |
1002 | 25.00 |
1003 | 220.00 |
1004 | 200.00 |
jobid | datein | total | chargeto | payid | paymentamount | paymentjobno | paymentdate | paymenttype |
---|---|---|---|---|---|---|---|---|
1000 | 2019-10-01 | 100.00 | 4 | 1 | 25.00 | 1000 | 2019-10-01 | 1 |
1000 | 2019-10-01 | 100.00 | 4 | 1 | 25.00 | 1000 | 2019-10-01 | 1 |
1000 | 2019-10-01 | 100.00 | 4 | 1 | 25.00 | 1000 | 2019-10-01 | 1 |
1000 | 2019-10-01 | 100.00 | 4 | 1 | 25.00 | 1000 | 2019-10-01 | 1 |
1001 | 2019-10-01 | 50.00 | 4 | 2 | 50.00 | 1001 | 2019-10-01 | 1 |
1002 | 2019-10-01 | 25.00 | 4 | 3 | 25.00 | 1002 | 0201-10-01 | 1 |
1003 | 2019-10-01 | 220.00 | 6 | 4 | 220.00 | 1003 | 2019-10-01 | 1 |
1004 | 2019-10-01 | 200.00 | 7 | 5 | 200.00 | 1004 | 2019-10-01 | 1 |
jobid | payment_hist |
---|---|
1000 | 25.00, 25.00, 25.00, 25.00 |
1001 | 50.00 |
1002 | 25.00 |
1003 | 220.00 |
1004 | 200.00 |