Oracle对树形结构按级次排序SQL

最新推荐文章于 2023-03-14 21:05:50 发布

weixin_30729609

最新推荐文章于 2023-03-14 21:05:50 发布

阅读量1k

点赞数

文章标签：数据库数据结构与算法

原文链接：http://www.cnblogs.com/heroking2000/archive/2009/10/12/1581696.html

版权

1、自顶向下查找
select t.name, t.id
from tree t
start with t.id = 'top'
CONNECT BY PRIOR t.id = t.parent_id
order SIBLINGS by t.order_no
2、自底向上查找
select t.name, t.id
from tree t
start with t.id = 'top'
CONNECT BY PRIOR t.parent_id = t.id
order SIBLINGS by t.order_no

转载于:https://www.cnblogs.com/heroking2000/archive/2009/10/12/1581696.html