By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| NODE_ID | PARENT_ID | SHORT_NAME | LEV | SEQNUM |
|---|---|---|---|---|
| 1 | null | Parent Node-1 | 2 | 1 |
| 2 | null | Parent Node-1 | 2 | 1 |
| 3 | null | Parent Node-1 | 2 | 1 |
| 4 | null | Parent Node-1 | 3 | 1 |
| 5 | null | Parent Node-1 | 3 | 1 |
| 6 | null | Parent Node-1 | 4 | 1 |
| 7 | null | Parent Node-1 | 5 | 1 |
| N |
|---|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |