orcale 的递归查询以及坑

最新推荐文章于 2022-07-26 18:41:30 发布

祎木一世界

最新推荐文章于 2022-07-26 18:41:30 发布

阅读量280

点赞数

分类专栏：日常记录

本文链接：https://blog.csdn.net/tttmdds/article/details/77963662

版权

日常记录专栏收录该内容

10 篇文章 0 订阅

订阅专栏

1、无条件查询

SELECT USER_ID
    FROM MP_USER_RELATION
              START WITH MANAGER_ID = '0000000048f260cf0148f2fefc860004'
              CONNECT BY USER_ID = MANAGER_ID

2、有条件查询

错误写法：

SELECT USER_ID
    FROM MP_USER_RELATION
        where RELATION_STATUS= 1
              START WITH MANAGER_ID = '402879bb56011d710156013cae460003'
              CONNECT BY USER_ID = MANAGER_ID

正确写法

SELECT USER_ID
    FROM (SELECT* FROM MP_USER_RELATION WHERE RELATION_STATUS = 1 )
         START WITH MANAGER_ID = '402879bb56011d710156013cae460003'
         CONNECT BY USER_ID = MANAGER_ID