By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| ID | Admit_Dt | Discharge_Dt |
|---|---|---|
| 1 | 2020-12-30 00:00:00.000 | 2021-07-14 00:00:00.000 |
| 2 | 2021-03-04 00:00:00.000 | 2021-03-25 00:00:00.000 |
| 2 | 2021-05-01 00:00:00.000 | 2021-05-10 00:00:00.000 |
| 3 | 2021-06-01 00:00:00.000 | 2021-06-05 00:00:00.000 |
Warning: Null value is eliminated by an aggregate or other SET operation.