SELECT
*
FROM
(
SELECT
*
FROM TABLE_NAME
CONNECT BY PRIOR _LEVEL_ID = _UPPER_LEVEL_ID
AND _NUM <= 2
START WITH _UPPER_LEVEL_ID IN
(
SELECT
_LEVEL_ID
FROM TABLE_NAME
WHERE _UPPER_LEVEL_ID = 'xxx'
AND _NUM > 2
)
AND _NUM <= 2)
WHERE _NUM <= 2
ORDER BY _UPPER_LEVEL_ID;
已知某结点 查询其下全部子结点无限递归的前2个数据
ORACLE 树形结构数据 查询某结点下全部子节点无限递归的前2个数据
最新推荐文章于 2021-04-03 01:59:24 发布