这样的语句怎么写啊

linkadmin

表test

day      name
1          jia
1          yi
2          jia
2          bing
3          ding
查询出以下的结果
day       name
1           jia;yi
2           jia;bing
3           ding
谢谢！

linkadmin

顶:wink:

linkadmin

大家帮忙看一下啊，谢谢啊

linkadmin

我顶啊

doni

SQL解决不了
用PL/SQL或其他编程语言

dingning239

使用pl/sql代码块来实现，通过定义游标来做

williamshcx

create table test(id varchar2(10),mc varchar2(50));
insert into test values('1','11111');
insert into test values('1','22222');
insert into test values('2','11111');
insert into test values('2','22222');
insert into test values('3','11111');
insert into test values('3','22222');
insert into test values('3','33333');

commit;
select id,ltrim(max(sys_connect_by_path(mc,';')),';') add_mc from (
select id,mc,row_number() over(partition by id order by id) rn_by_id,
row_number() over (order by id) + id rn from test
)
start with rn_by_id = 1 connect by rn - 1 = prior rn
group by id
order by id;
你试下这个看看.

Chinese_Dragon

Terrific !!

linkadmin

强！顶！！！谢谢！！！

vl_sky

原帖由 williamshcx 于 2008-4-22 11:26 发表
create table test(id varchar2(10),mc varchar2(50));
insert into test values('1','11111');
insert into test values('1','22222');
insert into test values('2','11111');
insert into test values(' ...

你太有才了。