By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| OrganizationTypeID | OrganizationTypeID | ParentName | ChildName | res |
|---|---|---|---|---|
| 1 | 1 | parent | parent | parent |
| 1 | 2 | parent | child 1 | parent>child 1 |
| 1 | 3 | parent | child 2 | parent>child 2 |
| 5 | 5 | parent 5 | parent 5 | parent 5 |