Skip to content
Advertisement

Performing subtraction in SQL/finding the balance

SQL table here: http://sqlfiddle.com/#!9/abe1da/9

Current Table:

Year Month Type Accounts Amount
2021 1 Actual abc 20
2021 1 Actual def 30
2021 1 Actual ghi 40
2021 1 Actual X 7
2021 1 Actual Y 3
2021 1 Actual final 105

Expected

Year Month Type Accounts Amount
2021 1 Actual abc 20
2021 1 Actual def 30
2021 1 Actual ghi 40
2021 1 Actual X 7
2021 1 Actual Y 3
2021 1 Actual final 105
2021 1 Actual BALANCE 5

SQL Attempt

Note: That balance of 5 represents thousands of small accounts which currently do not form part of a database.

Advertisement

Answer

If I understand correctly:

Here is a db<>fiddle.

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement