sqlserver2005 递归查询

发布时间：2020-12-12 15:49:08 所属栏目：MsSql教程来源：网络整理

导读：--递归查询:从上往下搜索 with playadminCTE(plaparentid,plaid,platask,ilayer) as ( select plaparentid,ilayer=1 from playadmin where plapadid=325 and plaparentid is null and plaid=307 union all select a.plaparentid,a.plaid,a.platask,ilayer+1

--递归查询:从上往下搜索
with playadminCTE(plaparentid,plaid,platask,ilayer)
as
(
select plaparentid,ilayer=1 from playadmin where plapadid=325
and plaparentid is null and plaid=307
union all
select a.plaparentid,a.plaid,a.platask,ilayer+1
from playadmin a INNER join playadminCTE b on
a.plaparentid=b.plaid --and b.plaid=6295
) --递归查询:从下往上搜索 with playadminCTE(plaparentid,ilayer) as ( select plaparentid,ilayer=1 from playadmin where plaparentid is not null and plaid=6296 union all select a.plaparentid,ilayer=ilayer+1 from playadmin a INNER join playadminCTE b on b.plaparentid=a.plaid )

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!