楼主,其实你没有叶子节点的树干,其实本身就是一个叶子节点、
此处我给出一个sql去除你的树干和叶子节点不相符的记录; select * from treetest t
where CONNECT_BY_ISLEAF = yzbz
connect by prior id = P_id START WITH P_id = '0';看看是否可行?
此处我给出一个sql去除你的树干和叶子节点不相符的记录; select * from treetest t
where CONNECT_BY_ISLEAF = yzbz
connect by prior id = P_id START WITH P_id = '0';看看是否可行?
select T.*
from treetest t
connect by prior p_id = id
START WITH id in ('3_2_1', '3_3_1');
反过来就可以啦