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 |