By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| GroupID | DepartmentList |
|---|---|
| 1 | D006 |
| 2 | D005,D006,D007 |
| 3 | D001,D002,D004,D006,D009 |
| 5 | D002 |
| GroupID | DepartmentList |
|---|---|
| 1 | D006 |
| 2 | D005,D006,D007 |
| 3 | D001,D002,D004,D006,D009 |
| 5 | D002 |