Binary Tree Nodes

  • + 13 comments

    Probably this will be even simpler: select N, case when P is NULL then 'Root' when N in (select P from BST) then 'Inner' else 'Leaf' end as Node from BST order by N;