Class类型设计

最新推荐文章于 2022-11-26 22:15:59 发布

tange_zhou

最新推荐文章于 2022-11-26 22:15:59 发布

阅读量229

点赞数

分类专栏：【SqlServer】文章标签： class c

本文链接：https://blog.csdn.net/tange_zhou/article/details/6221894

版权

【SqlServer】专栏收录该内容

11 篇文章 0 订阅

订阅专栏

--获取父类型
with c as (
select * from testtype where T_ID = 4
union all
select a.* from testtype a
join c on a.T_ID = c.ParentID
)
select top 1 * from c order by T_ID asc

--获取子类型
with c as (
select * from testtype where T_ID = 1
union all
select a.* from testtype a
join c on a.ParentID = c.T_ID
)
select * from c order by T_ID asc