Oracle

SQL — Classify Tree Nodes as Root, Inner, or Leaf

Members only

Given a `Tree` table with `id` and `pid` (parent id), write one SQL query that labels every node as `Root` (no parent), `Inner` (has a parent and at least one child), or `Leaf` (has a parent and no ch...