By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
13 rows affected
child | parent | rlevel |
---|---|---|
a | null | 0 |
m | null | 0 |
x | null | 0 |
b | a | |
c | a | |
d | a | |
e | a | |
f | a | |
g | a | |
h | a | |
i | a | |
j | a | |
k | a | |
n | a | |
y | a | |
z | a | |
e | b | |
f | b | |
g | b | |
h | b | |
i | b | |
j | b | |
k | b | |
n | b | |
y | b | |
z | b | |
h | c | |
i | c | |
j | c | |
k | c | |
n | c | |
y | c | |
z | c | |
j | d | |
k | d | |
n | d | |
y | d | |
z | d | |
k | f | |
n | f | |
y | f | |
z | f | |
n | m | |
y | m | |
z | m | |
y | x | |
z | x | |
z | y |