SQL> select o.p as "排列" from
2 (select replace (sys_connect_by_path( value, ',' ) , ',' ) p
3 from users connect by nocycle value != prior value) o
4 where length(o.p) =3;
各位大侠帮帮忙
...全文
983打赏收藏
oracle转sqlserver 求助
SQL> select o.p as "排列" from 2 (select replace (sys_connect_by_path( value, ',' ) , ',' ) p 3 from users connect by nocycle value != prior value) o 4 where length(o.p) =3; 各位大侠帮帮忙
NAME VALUE ID
---- ----- ----------
甲 a 1
乙 b 2
丙 c 3
丁 d 4
SQL> select o.p as "排列" from
2 (select replace (sys_connect_by_path( value, ',' ) , ',' ) p
3 from users connect by nocycle value != prior value) o
4 where length(o.p) =2;
排列
--------------------------------------------------------------------------------
ab
ac
ad
ba
bc
bd
ca
cb
cd
da
db
dc
12 rows selected
SQL> select o.p as "排列" from
2 (select replace (sys_connect_by_path( value, ',' ) , ',' ) p
3 from users connect by nocycle value != prior value) o
4 where length(o.p) =3;
排列
--------------------------------------------------------------------------------
abc
abd
acb
acd
adb
adc
bac
bad
bca
bcd
bda
bdc
cab
cad
cba
cbd
cda
cdb
dab
dac