You are viewing a single comment's thread. Return to all comments →
SELECT N, CASE WHEN P IS NULL THEN 'Root' WHEN N IN (SELECT DISTINCT P FROM bst) THEN 'Inner' ELSE 'Leaf' END AS NodeType FROM bst ORDER BY N;
Seems like cookies are disabled on this browser, please enable them to open this website
Binary Tree Nodes
You are viewing a single comment's thread. Return to all comments →
SELECT N, CASE WHEN P IS NULL THEN 'Root' WHEN N IN (SELECT DISTINCT P FROM bst) THEN 'Inner' ELSE 'Leaf' END AS NodeType FROM bst ORDER BY N;