递归查询所有子集

with myCte as
 (
 select * from RS_Comment where id=10000004
 union all
 select RS_Comment.* from  RS_Comment
    inner join myCte on  RS_Comment.ParantID=myCte.id
 )
select * from myCte

转载于:https://www.cnblogs.com/huweijun/p/3880096.html