- Prepare
- SQL
- Advanced Select
- Binary Tree Nodes
- Discussions
Binary Tree Nodes
Binary Tree Nodes
+ 0 comments SELECT N, CASE WHEN P IS NULL THEN "Root" WHEN N IN (SELECT P FROM BST) THEN "Inner" ELSE "Leaf" END FROM BST ORDER BY N;
+ 0 comments /* Enter your query here. */ SELECT N, CASE WHEN P IS NULL THEN 'Root' WHEN N IN (SELECT P FROM BST) THEN 'Inner' ELSE 'Leaf' END FROM BST ORDER BY N;
+ 0 comments SELECT CASE WHEN P IS NULL THEN N WHEN N IN (SELECT DISTINCT P FROM BST) THEN N ELSE N END AS rn1, CASE WHEN P IS NULL THEN "Root" WHEN N IN (SELECT DISTINCT P FROM BST) THEN "Inner" ELSE "Leaf" END AS rn2 FROM BST ORDER BY rn1;
+ 0 comments select n, case when p is null then 'Root' else case when n in (select p from bst) then 'Inner' else 'Leaf' END end from bst order by n;
+ 0 comments SELECT N,
CASE WHEN P IS NULL THEN 'Root' WHEN N IN (SELECT P FROM BST ) THEN 'Inner' ELSE 'Leaf' END NODE_TYPE FROM BST ORDER BY 1;
Sort 1886 Discussions, By:
Please Login in order to post a comment