By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | Name | Parent | Code |
|---|---|---|---|
| 1 | Item1 | null | K123 |
| 2 | Item2 | null | K324 |
| 3 | Item3 | 1 | K123 |
| 4 | Item4 | 2 | K324 |
| 5 | Item5 | 3 | K123 |
| 6 | Item6 | 5 | K123 |
| 7 | Item7 | 4 | K324 |
| 8 | Item8 | null | K567 |
| 9 | Item9 | 8 | K567 |
| 10 | Item10 | null | null |