By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
| PersonID | CompanyID | new_dt |
|---|---|---|
| A12 | abc | 2020-05-01 |
| B23 | def | 2020-06-08 |
| B23 | def | 2020-06-09 |
| B23 | def | 2020-06-10 |
| B23 | def | 2020-06-11 |
| B23 | def | 2020-06-12 |
| B23 | def | 2020-06-13 |
| B23 | def | 2020-06-14 |
| A12 | abc | 2020-05-02 |
| A12 | abc | 2020-05-03 |