LeetCode--608. 树节点

解题思路

如果p_id里没有id，说明此id是叶子节点

select id, case when p_id is null then 'Root' when id in (select p_id from tree) then 'Inner' else 'Leaf' end as type from tree;