?LeetCode刷題實戰(zhàn)608：樹節(jié)點
解題
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下載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
感谢您访问我们的网站，您可能还对以下资源感兴趣：
国产秋霞理论久久久电影-婷婷色九月综合激情丁香-欧美在线观看乱妇视频-精品国avA久久久久久久-国产乱码精品一区二区三区亚洲人-欧美熟妇一区二区三区蜜桃视频