oracle
-
编辑 删除
start with ... connect by 的理解
对于使用sys_connect_by_path函数来得到树型结构信息的平铺，但是使用过程中发现，有很多实现了但是查出来的数据不对。如：select deptno,ltrim(sys_connect_by_path(ename,','),',') path from (select deptno,ename,row_number() over (order by deptno) node_id,row_number() over (partition by deptno order by deptno) rn from emp)start with rn=1connect by node_id- 1 = prior node_id1 10 CLARK2 10 CLARK,KING3 10 CLARK,KING,MILLER4 20 CLARK,KING,MILLER,SMITH5 20 CLARK,KING,MILLER,SMITH,ADAMS6 20 CLARK,KING,MILLER,SM
