?LeetCode刷題實(shí)戰(zhàn)608：樹節(jié)點(diǎn)
解題
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
ORDER?BY?id
評論
圖片
表情
下載APP<b id="afajh"><abbr id="afajh"></abbr></b>
下載APP解題
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
ORDER?BY?id
<b id="afajh"><abbr id="afajh"></abbr></b>