By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ID | ord | parent | name |
---|---|---|---|
100 | 1 | 0 | X |
150 | 0 | 100 | X.1 |
200 | 2 | 0 | Y |
300 | 0 | 200 | Y.1 |
ID | ord | parent | name |
---|---|---|---|
100 | 1 | 0 | X |
150 | 0 | 100 | X.1 |
200 | 2 | 0 | Y |
300 | 0 | 200 | Y.1 |