MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE transactions
             (id integer PRIMARY KEY AUTO_INCREMENT,
              bank_id integer,
              account_id integer,
              amount decimal(38, 2),
              balance decimal(38, 2));
ALTER TABLE transactions
            DROP balance;
INSERT INTO transactions
            (bank_id,
             account_id,
             amount)
            VALUES (1,
                    1,
                    100),
                   (1,
                    1,
                    125.00),
                   (1,
                    1,
                    -73.00);
CREATE VIEW transactions_with_balance
AS
SELECT t1.*,
       sum(amount) OVER (PARTITION BY t1.bank_id,
                                      t1.account_id
                         ORDER BY t1.id) balance
       FROM transactions t1;
SELECT *
       FROM transactions_with_balance;


id
bank_id
account_id
amount
balance


1
1
1
100.00
100.00

2
1
1
125.00
225.00

3
1
1
-73.00
152.00