By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
ID | theDate | Amt | prevDate |
---|---|---|---|
A | 10-10-2017 | 90 | null |
A | 04-04-2018 | 110 | null |
A | 03-03-2018 | 110 | 02-02-2018 |
A | 02-02-2018 | 100 | 10-10-2017 |
B | 10-10-2018 | 90 | null |
B | 09-09-2018 | 90 | 07-07-2018 |
B | 07-07-2018 | 80 | null |