不用安装即可体验dm7

myth8860

jllioo0 发表于 2014-6-20 14:11
试用了下，效果很好。。

好在哪里？

〇〇

with t as(
select 'a' u, 'bj' b, 'sh' e from dual union all
select 'a' u, 'sh' b, 'gz' e from dual union all
select 'b' u, 'bj' b, 'wh' e from dual union all
select 'b' u, 'wh' b, 'hk' e from dual union all
select 'c' u, 'bj' b, 'nj' e from dual)
select u,max(sys_connect_by_path(e,'/'))
from t
connect by prior u=u and prior e=b
start with b not in(select e from t t1 where t.u=t1.u)
group by u;

myth8860

〇〇 发表于 2015-1-20 01:48
with t as(
select 'a' u, 'bj' b, 'sh' e from dual union all
select 'a' u, 'sh' b, 'gz' e from dual ...

什么情况？