表結構?
?
sql語句
--SELECT * FROM T_VIPPart
with cte as
(
SELECT RecID, VIPId,ParentID,MenuName,Content,LinkURL,CreateTime ,Islink from T_VIPPart
where ParentID=0 AND IsDeleted=0 AND Status=3
union ALL
SELECT s.RecID, s.VIPId,s.ParentID,s.MenuName,s.Content,s.LinkURL,s.CreateTime,s.Islink
from cte s inner join T_VIPPart d
on s.RecID = d.ParentID
)
select * from cte
要求是ParentID=0 是根節點 ?查詢 ParentID=0的子集
sql 遞歸查詢 急 路過的朋友看看
慕尼黑8549860
2018-12-06 18:38:02
