sql获取本身及后代节点数据
sql获取本身及后代节点数据
with #tmp as(
select * from PRD_DW where DWBH in(‘01’)
union all
select a.* from PRD_DW a, #tmp b where a.PARENTID = b.DWBH and a.PARENTID!=a.DWBH and b.PARENTID!= b.DWBH )
select distinct DWBH from #tmp
原创
2020-09-02 20:20:08 ·
177 阅读 ·
0 评论