FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
leetcode-solutions/MySQL/binary-tree-nodes.sql at master · swapycoder/leetcode-solutions · GitHub
swapycoder
/
leetcode-solutions
Public
forked from
kamyu104/LeetCode-Solutions
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
leetcode-solutions
/
MySQL
/
binary-tree-nodes.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
11 lines (10 loc) · 226 Bytes
Breadcrumbs
leetcode-solutions
/
MySQL
/
binary-tree-nodes.sql
Copy path
File metadata and controls
11 lines (10 loc) · 226 Bytes
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
#
Time: O(nlogn)
#
Space: O(n)
SELECT
N,
CASE
WHEN P IS
NULL
THEN
'
Root
'
WHEN N
IN
(
SELECT DISTINCT
P
FROM
Tree) THEN
'
Inner
'
ELSE
'
Leaf
'
END
AS
Type
FROM
Tree
ORDER BY
1
ASC
;
Back
|
FazBrowse Home
|
New Git URL