select a.* from (SELECT groupid, groupname, parentgroupid, level FROM group START WITH parentgroupid = 0 CONNECT BY PRIOR groupid = parentgroupid) a where not exists(select 1 from group where parentgroupid = a.groupid)
或者:select a.* from (SELECT groupid, groupname, parentgroupid, level FROM group START WITH parentgroupid = 0 CONNECT BY PRIOR groupid = parentgroupid) a where a.groupid not in(select distinct parentgroupid from group)
a.*
from
(SELECT
groupid,
groupname,
parentgroupid,
level
FROM
group
START WITH
parentgroupid = 0
CONNECT BY PRIOR
groupid = parentgroupid) a
where
not exists(select 1 from group where parentgroupid = a.groupid)
a.*
from
(SELECT
groupid,
groupname,
parentgroupid,
level
FROM
group
START WITH
parentgroupid = 0
CONNECT BY PRIOR
groupid = parentgroupid) a
where
a.groupid not in(select distinct parentgroupid from group)