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 |