所有下级
递归查询所有下级with a as(select * from HrmDepartment where
supdepid = 0
union all select HrmDepartment.* from a, HrmDepartment where a.id = HrmDepartment.supdepid)
select * from a
–查询部门ID为0的所有下级部门
【泛微ecology】查询部门ID为0的所有下级部门-递归查询
最新推荐文章于 2023-12-05 20:19:14 发布