利用sql树查询获得树上的叶子节点 fourfire · 2006-12-23 21:08 · Markdown 如下 sql 代码 SELECT ond.parentid as id FROM orgnode ond where ond.flag = 1 START WITH ond.id=1 CONNECT BY PRIOR ond.id = ond.parentid group by ond.parentid having COUNT(*)=1