sql Bom 递归查询:
with t as(
select * from Department where id=6
union all
select a.* from Department a,t where a.ParentId=t.id)
select * from t
2024-01-31 19:17:40
sql Bom 递归查询:
with t as(
select * from Department where id=6
union all
select a.* from Department a,t where a.ParentId=t.id)
select * from t