会python真的可以为所欲为0(回)
355天前
这里还有人吗1(回)
540天前这里还有人吗0(回)
540天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
765天前到处都是羊，不想上班0(回)
845天前
鸽子
0(回)
849天前create table #users (name char(2),value char(1),id number); |
insert into #users values('甲','a',1); |
insert into #users values('乙','b',2); |
insert into #users values('丙','c',3); |
insert into #users values('丁','d',4); |
commit; |
--2个元素全排列 |
select o.p as "排列" from |
(select replace (sys_connect_by_path( value, ',' ) , ',' ) p |
from #users connect by nocycle value != prior value) o |
where length(o.p) =2; |
--3个元素全排列 |
select o.p as "排列" from |
(select replace (sys_connect_by_path( value, ',' ) , ',' ) p |
from #users connect by nocycle value != prior value) o |
where length(o.p) =3; |
--4个元素全排列 |
select o.p as "排列" from |
(select replace (sys_connect_by_path( value, ',' ) , ',' ) p |
from #users connect by nocycle value != prior value) o |
where length(o.p) =4; |
by: 发表于：2017-09-22 09:43:15 顶(0) | 踩(0) 回复
？？
回复评论