By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| Code | Parent | Level |
|---|---|---|
| D | B | 1 |
| D | L | 2 |
| D | P | 3 |
| D | D | 4 |
| G | A | 1 |
| G | B | 2 |
| G | C | 3 |
| G | G | 4 |
| H | A | 1 |
| H | B | 2 |
| H | C | 3 |
| H | G | 4 |
| H | H | 5 |
| R | J | 1 |
| R | X | 2 |
| R | R | 3 |
4 rows affected
| Code | Parent | Level |
|---|---|---|
| D | B | 1 |
| D | L | 2 |
| D | P | 3 |
| D | D | 4 |
| G | A | 1 |
| G | B | 2 |
| G | C | 3 |
| G | G | 4 |
| H | A | 1 |
| H | B | 2 |
| H | C | 3 |
| H | G | 4 |
| H | H | 5 |
| R | J | 1 |
| R | X | 2 |
| R | R | 3 |