我自己找了一个方法,但看不懂,有没有能看懂的,给我讲一下好吗select c1, c2 from ( select c1, rtrim(c2 ||', '|| lead(c2 ,1) over (partition by c1 order by c2 ) ||', '|| lead(c2 ,2) over (partition by c1 order by c2 ) ||', '|| lead(c2 ,3) over (partition by c1 order by c2 ) ||', '|| lead(c2 ,4) over (partition by c1 order by c2 ) ||', '|| lead(c2 ,5) over (partition by c1 order by c2 ),', ') c2, row_number () over (partition by c1 order by c2 ) x from table1 where c1= c1 ) where x = 1
from table_t
group by c1好像没有集记的函数能够联接字符串的
但是要做到一起难啊
不如用java程序来实现哈哈
我要连接,
c1 c2
--------------
1 我,是,谁
2 知,道
3 不
中间最好能自动添加一个逗号
select c1, rtrim(c2 ||', '||
lead(c2 ,1) over (partition by c1
order by c2 ) ||', '||
lead(c2 ,2) over (partition by c1
order by c2 ) ||', '||
lead(c2 ,3) over (partition by c1 order by c2 ) ||', '||
lead(c2 ,4) over (partition by c1
order by c2 ) ||', '||
lead(c2 ,5) over (partition by c1
order by c2 ),', ') c2,
row_number () over (partition by c1
order by c2 ) x
from table1 where c1= c1 )
where x = 1