By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
14 rows affected
| ParentID | Level_1 | Level_2 | Level_3 | Level_4 | Level_5 | Level_6 |
|---|---|---|---|---|---|---|
| CR001 | DR001 | DR002 | null | null | null | null |
| CR002 | DR003 | null | null | null | null | null |
| DR001 | ER001 | null | null | null | null | null |
| ER001 | ER003 | ER004 | ER005 | null | null | null |
| ER002 | ER006 | null | null | null | null | null |
| PR001 | CR001 | CR002 | CR003 | ER007 | ER007 | ER007 |
Warning: Null value is eliminated by an aggregate or other SET operation.