add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
id balance_date balance
1 2018-10-01 00:00:00.000 111
1 2018-10-02 00:00:00.000 115
12 2017-10-01 00:00:00.000 1134
12 2017-09-01 00:00:00.000 159
1 2018-09-02 00:00:00.000 130
5 2018-09-02 00:00:00.000 150
id last_balance_date last_balance prev_balance_date prev_balance
1 2018-10-02 00:00:00.000 115 2018-10-01 00:00:00.000 111
5 2018-09-02 00:00:00.000 150 null null
12 2017-10-01 00:00:00.000 1134 2017-09-01 00:00:00.000 159
id balance_date balance r
1 2018-10-02 00:00:00.000 115 1
1 2018-10-01 00:00:00.000 111 2
1 2018-09-02 00:00:00.000 130 3
5 2018-09-02 00:00:00.000 150 1
12 2017-10-01 00:00:00.000 1134 1
12 2017-09-01 00:00:00.000 159 2