By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| EPISODE_ID | ADMITDATE_DT | DISDATE_DT | ULI | ADMISSION_TYPE |
|---|---|---|---|---|
| 1 | 01-JAN-22 | 02-JAN-22 | 001 | index |
| 1 | 02-JAN-22 | 10-JAN-22 | 001 | transfer |
| 1 | 10-JAN-22 | 20-JAN-22 | 001 | transfer |
| 2 | 01-JAN-22 | 05-JAN-22 | 002 | index |
| 3 | 10-JAN-22 | 20-JAN-22 | 002 | index |
| 3 | 20-JAN-22 | 25-JAN-22 | 002 | transfer |