select z.ID,z.parentid,z.ProjectName,z.isleaf from (
SELECT w.ID, w.parentid, w.ProjectName,CONNECT_BY_ISLEAF isleaf
from (select a.ID, a.parentid, a.ProjectName
FROM bo_project a, bo_planproject b
WHERE b.projectid = a.ID
AND B.ISCANCEL <> 2
) w
start with w.parentid = 0
connect by prior w.id = w.parentid
)z where z.isleaf=1
获取树叶子节点数据
最新推荐文章于 2021-02-27 19:45:46 发布