SQL递归查询

分类: IT文章 • 2024-12-14 18:48:36

场景：sql递归查询全部子集

sql递归查询所有子集

sql递归查询所有子集

select * from bg_organization

SQL递归查询

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递归查询