sql 递归查询
with my1 as(
select * from JTZK_Comment where Status=1
union all
select JTZK_Comment.* from my1,JTZK_Comment where my1.id= JTZK_Comment.ParentId
)
select DISTINCT * from my1;
sql 递归查询
with my1 as(
select * from JTZK_Comment where Status=1
union all
select JTZK_Comment.* from my1,JTZK_Comment where my1.id= JTZK_Comment.ParentId
)
select DISTINCT * from my1;