sql递归查询所有子集
select * from bg_organization
with a as(
select * from bg_organization where orgid=1
union all
select x.* from bg_organization x,a
where x.pid=a.orgid)
select * from a
sql递归查询所有子集
sql递归查询所有子集
select * from bg_organization
with a as(
select * from bg_organization where orgid=1
union all
select x.* from bg_organization x,a
where x.pid=a.orgid)
select * from a
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
