SQL : Binary Tree Nodes Problem
Hello All, We are back with another SQL problem, focusing on use case of SQL CASE statement. CASE statement works similar to that of IF - ELSE ladder in other programming languages. This problem requires use of CONCAT() function. You can visit following learning resources related to this particular question : 1. SQL CASE statement - SQL CASE Statement (w3schools.com) 2. concat function - CONCAT (Transact-SQL) - SQL Server | Microsoft Docs The problem below is sourced from HackerRank. You can visit the link: Binary Tree Nodes | HackerRank Give a try to solve below problem. Solution is provided as usual. Feel free to comment if any queries and also suggest alternate approach to solve this problem. Have a Happy Learning ! You are given a table, BST , containing two columns: N and P, where N represents the value of a node in Binary Tree , and P is the parent of N . Write a query to ...