- 博客(1)
- 收藏
- 关注
原创 sql 查询子级和父级
递归方式 --子级 with cte as ( select 0 as LVL,* from Customer with (nolock) where CId =636 union all select LVL+1 ,c.* from Customer c with (nolock) join cte p on c.ParentId = p.CId ) select * from ct...
2017-10-20 10:23:24 2850
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人