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 |
1 | 5 | parent | parent 5 | parent |
5 | 1 | parent 5 | parent | parent 5 |
5 | 2 | parent 5 | child 1 | parent 5>child 1 |
5 | 3 | parent 5 | child 2 | parent 5>child 2 |
5 | 5 | parent 5 | parent 5 | parent 5 |
OrganizationTypeID | ParentOrganizationTypeID | Name | childname | res |
---|---|---|---|---|
1 | null | parent | parent | parent |
1 | 2 | parent | child 1 | parent>child 1 |
1 | 3 | parent | child 2 | parent>child 2 |
5 | null | parent 5 | parent 5 | parent 5 |