By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
Level | GroupID | GroupName | ParentID | ParentName |
---|---|---|---|---|
1 | A | Level1 | null | null |
2 | B | Level2 | A | Level1 |
3 | C | Level3 | B | Level2 |
5 rows affected
Level | GroupID | GroupName | ParentID | ParentName |
---|---|---|---|---|
1 | A | Level1 | null | null |
2 | B | Level2 | A | Level1 |
3 | C | Level3 | B | Level2 |