We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Advanced Select
  4. Binary Tree Nodes
  5. Discussions

Binary Tree Nodes

Sort by

recency

|

2467 Discussions

|

  • rjd19972
     + 0 comments

    SELECT N, CASE WHEN p IS NULL then 'Root' WHEN N IN (SELECT p FROM BST WHERE p IS NOT NULL) THEN 'Inner' else 'Leaf' end FROM BST order by N

  • varunsaraswat310
     + 0 comments

    **SELECT N, CASE WHEN P IS NULL THEN 'Root' WHEN N NOT IN (SELECT P FROM BST WHERE P IS NOT NULL) THEN 'Leaf' ELSE 'Inner' END FROM BST ORDER BY N ; **

  • varunsaraswat310
     + 0 comments

    SELECT N, CASE WHEN P IS NULL THEN 'Root' WHEN N NOT IN (SELECT P FROM BST WHERE P IS NOT NULL) THEN 'Leaf' ELSE 'Inner' END FROM BST ORDER BY N ;

  • h2024180041
     + 0 comments

    select N , IF(p is NULL, 'Root', IF(N in (select p from BST where p is not NUll), 'Inner','Leaf'))

    from BST order by N;

  • samuel2ayman
     + 0 comments
    SELECT N,
 CASE 
  WHEN p IS NULL then 'Root'
  WHEN N NOT IN (SELECT p FROM BST WHERE p IS NOT NULL) THEN 'Leaf' 
  else 'Inner'
 end
FROM BST 
order by N