By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| employeeId | DepartmentCode | StartDate | (No column name) |
|---|---|---|---|
| 1 | 978 | 2022-01-01 | 2022-03-01 |
| 1 | 928 | 2022-03-01 | 2022-04-01 |
| 1 | 978 | 2022-04-01 | 2022-06-01 |
| 1 | 911 | 2022-06-01 | 9999-12-31 |