By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 18 Duplicates: 0 Warnings: 0
| id | account_no | debit_balance | credit_balance |
|---|---|---|---|
| 1 | 13 | 32578.19 | 0 |
| 2 | 13 | 1500 | 0 |
| 3 | 13 | 1500000 | 0 |
| 4 | 13 | 1500 | 0 |
| 5 | 14 | 1500000 | 0 |
| 6 | 14 | 0 | 13500 |
| 7 | 14 | 0 | 13500 |
| 8 | 14 | 33458.43 | 0 |
| 9 | 15 | 0 | 100000 |
| 10 | 15 | 18506.34 | 0 |
| 11 | 16 | 946.2 | 0 |
| 12 | 17 | 90364.77 | 0 |
| 13 | 21 | 0 | 0 |
| 14 | 22 | 0 | 0 |
| 15 | 23 | 0 | 0 |
| 16 | 23 | 1105500 | 0 |
| 17 | 24 | 1327 | 0 |
| 18 | 25 | 0 | 0 |
| id | account_no | debit_balance | credit_balance | balance |
|---|---|---|---|---|
| 1 | 13 | 32578.19 | 0 | 32578.19 |
| 2 | 13 | 1500 | 0 | 34078.19 |
| 3 | 13 | 1500000 | 0 | 1534078.19 |
| 4 | 13 | 1500 | 0 | 1535578.19 |
| 5 | 14 | 1500000 | 0 | 1500000 |
| 6 | 14 | 0 | 13500 | 1486500 |
| 7 | 14 | 0 | 13500 | 1473000 |
| 8 | 14 | 33458.43 | 0 | 1506458.43 |
| 9 | 15 | 0 | 100000 | -100000 |
| 10 | 15 | 18506.34 | 0 | -81493.66 |
| 11 | 16 | 946.2 | 0 | 946.2 |
| 12 | 17 | 90364.77 | 0 | 90364.77 |
| 13 | 21 | 0 | 0 | 0 |
| 14 | 22 | 0 | 0 | 0 |
| 15 | 23 | 0 | 0 | 0 |
| 16 | 23 | 1105500 | 0 | 1105500 |
| 17 | 24 | 1327 | 0 | 1327 |
| 18 | 25 | 0 | 0 | 0 |