--Oracle
--取所有的上级代码
select a.fnumber,a.fid,a.fParentID,level from T_ORG_Admin a
start with a.fnumber = 'ZHPH' connect by prior a.FParentID = a.FID
order by level desc
--取所有的下级代码
select a.fnumber,a.fid,a.fParentID,level from T_ORG_Admin a
start with a.fnumber = 'ZHPH' connect by prior a.FID = a.FParentID
order by level
SQL查询所有上级/查询所有下级
最新推荐文章于 2023-08-04 17:25:59 发布