By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| OverallRN | RN | CID | XDATE | NEW_DATE |
|---|---|---|---|---|
| 1 | 1 | 0001 | 2020-03-21 | 2020-03-21 00:00:01.000 |
| 2 | 2 | 0001 | 2020-03-21 | 2020-03-21 00:00:02.000 |
| 3 | 3 | 0001 | 2020-03-21 | 2020-03-21 00:00:03.000 |
| 4 | 1 | 0002 | 2020-03-21 | 2020-03-21 00:00:01.000 |
| 5 | 2 | 0002 | 2020-03-21 | 2020-03-21 00:00:02.000 |