获取树叶子节点数据

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 = 0connect by prior w.id = w.parentid)z where z.isleaf=1 相关资源：敏捷开发V1.0.pptx