表: departInfo
列:
departId 主键,部门id
parentDepartId 父部门id
departLvl 部门级
departName 名称
请问如何查询,在不写过程一个个查的情况下?
------解决思路----------------------
SELECT DISTINCT departid, parentdepartid, departlvl, departname
FROM departinfo di
WHERE di.departlvl = 3
START WITH di.departlvl > 3
CONNECT BY PRIOR parentdepartid = departid
------解决思路----------------------
发现少写了个条件,呵呵
select connect_by_root(departId),connect_by_root(departName),departId
from departInfo
where connect_by_isleaf=1
start with departLvl>3
connect by prior parentDepartId=departId and prior departlvl>3