递归查询取值

wwlydkl

于 2024-01-11 15:17:59 发布

阅读量416

点赞数 8

分类专栏：数据库文章标签：数据库

本文链接：https://blog.csdn.net/wwlydkl/article/details/135530247

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

ORACLE

select id,name,parentid,level from (
SELECT id,name,parentid,level
FROM treeTable 
START WITH  id = '某某条件'-- 开始检索的条件
CONNECT BY PRIOR parentid= id)
where level=1 -- 取最上级

SQL Server

WITH TREE AS(
SELECT id,name,parentid,level
FROM treeTable
WHERE id ='条件'
UNION ALL
SELECT a.id,a.name,a.parentid,a.level
FROM treeTable a, TREE
WHERE  a.ID = TREE.parentid)
SELECT id,name,parentid,level FROM TREE
 where tree.level=1