You are viewing a single comment's thread. Return to all comments →
SELECT N,CASE WHEN ISNULL(P) THEN "Root" WHEN N IN (SELECT P FROM BST) THEN "Inner" ELSE "Leaf" END 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 ISNULL(P) THEN "Root" WHEN N IN (SELECT P FROM BST) THEN "Inner" ELSE "Leaf" END FROM BST ORDER BY N;