Oracle START WITH ... CONNECT BY PRIOR 带条件会有重复
来源:互联网 发布:深圳爱玩网络 编辑:程序博客网 时间:2024/05/01 12:59
查出当前节点下面的所有节点 因为要取表中的部分数据 所以要加条件
SELECT * FROM CFG_CPMP_DMN_TREE WHERE CLASSIFY = 'SCENE'
select * from cfg_cpmp_dmn_tree where classify='SCENE' start with code_val='1' connect by prior code_val=up_code_val
发现有很多重复的数据
正确应该是这样的
SELECT CODE_VAL, UP_CODE_VAL
FROM (SELECT * FROM CFG_CPMP_DMN_TREE WHERE CLASSIFY = 'SCENE')
-- WHERE IS_LEAF = 1-- 总限制取叶子节点
START WITH CODE_VAL = '1'
CONNECT BY PRIOR CODE_VAL = UP_CODE_VAL
1 0
- Oracle START WITH ... CONNECT BY PRIOR 带条件会有重复
- Oracle start with ... connect by prior 用法
- Oracle中start with...connect by prior
- Oracle start with...connect by prior用法
- Oracle start with connect by prior 用法
- oracle中start with connect by prior
- Oracle中connect by prior .... start with
- oracle start with connect by prior函数
- Oracle start with ... connect by prior 用法
- Oracle start with connect by prior 用法
- oracle start with connect by prior 用法
- Oracle Start With ...Connect By Prior
- Oracle:Start with connect by prior 递归
- connect by prior start with
- connect by prior start with
- CONNECT BY PRIOR... START WITH
- connect by prior start with
- Start With......Connect by prior..
- C#正则表达式小结
- 一、Lua中的类型与值
- Scikit-learn 安装
- JS为循环动态生成的节点添加点击事件
- 安卓智慧上海学习笔记系列——禁用ViewPager滑动事件
- Oracle START WITH ... CONNECT BY PRIOR 带条件会有重复
- 背包九讲之多重背包问题
- Leetcode 24 Swap Nodes in Pairs
- 仿微信-界面动画(9)--ListView有不同类别Item
- Github上传项目步骤和常见问题
- java 99乘法表
- stl中pair容器的用法
- UVa213
- Cookie防伪造