반응형
목록 HackerRank : Binary Tree Nodes (1)
KEEP GOING

https://www.hackerrank.com/challenges/binary-search-tree-1/problem Binary Tree Nodes | HackerRank Write a query to find the node type of BST ordered by the value of the node. www.hackerrank.com 1. 틀린 코드 SELECT N ,(CASE WHEN P IS NULL THEN 'Root', # 문제1 다중 조건 처리시 ',' 사용 안함 WHEN N IN (SELECT P FROM BST) THEN 'Inner' ELSE 'Leaf' )END AS 'NAME' # 문제2 END 처리 후 소괄호 처리해야 함 FROM BST ORDER BY N ASC 2. 정답..
code review/sql
2021. 12. 21. 18:25