By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| patient | claim | thru_dt | cd | start | new_start |
|---|---|---|---|---|---|
| 322 | 65 | 2020-02-01 | 42 | 2018-10-08 | 2018-10-08 |
| 322 | 65 | 2020-02-02 | 42 | null | 2018-10-08 |
| 322 | 95 | 2020-02-03 | 52 | null | 2018-10-08 |
| 122 | 5 | 2020-01-05 | 23 | null | null |
| 122 | 5 | 2020-01-15 | 42 | 2019-01-02 | 2019-01-02 |
| 122 | 5 | 2020-04-16 | 42 | null | null |