By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| id | startdate | seqnum | isrehire | anchordate |
|---|---|---|---|---|
| 123 | 2019-07-24 | 1 | N | 2019-07-24 |
| 123 | 2020-02-04 | 2 | Y | 2019-07-24 |
| 123 | 2020-08-25 | 3 | N | 2020-08-25 |
| 123 | 2020-12-20 | 4 | Y | 2020-08-25 |
| 123 | 2021-06-15 | 5 | Y | 2020-08-25 |
| 123 | 2021-08-20 | 6 | Y | 2020-08-25 |
| 123 | 2021-08-30 | 7 | N | 2021-08-30 |