By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| patientname | intervalname1 | intervalname2 | intervalname3 |
|---|---|---|---|
| Patient 1 | End | null | null |
| Patient 2 | Start | null | null |
| Patient 3 | Start | null | null |
| Patient 4 | End | 6-Month | Start |
| Patient 5 | 6-Month | null | null |
| Patient 6 | Start | End | null |
| Patient 7 | 6-Month | null | null |
Warning: Null value is eliminated by an aggregate or other SET operation.