Sybase IQ存储过程如何实现字符串拼接

[cplovejavaee]

表中数据:
ID UID
1 6000
1 7000
1 4000
2 6000
3 7000
3 5000
结果为
ID UID
1 6000,7000,4000
2 6000
3 7000,5000

[iihero]

(dba)> select id, list(uid) from testcc group by id order by id;
id          list(testcc.uid)


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1           6000,7000,4000


2           6000


3           7000,5000



(3 rows)

[cplovejavaee]

能详细点不,我没做过数据库,
刚来个新公司让我写存储过程,不太会

[wwwwb]

直接用SQL语句，在ASA11、12中有LIST
你试试SYBASE IQ是否支持LIST函数
select id, list(uid) from tt group by id

[cplovejavaee]

我试过了,没有List的

[wwwwb]

要用游标 or 变量累计
变量累计：示例，自行修改
ALTER PROCEDURE "zz"."blljtest"( )
BEGIN
declare @ee varchar(500);
declare @ee1 varchar(500);
declare @num int;
set @ee='';
set @ee1='';
set @num=1;
select *,space(500) as gd,0000 as gdnum into #tt from blljtest;
update #tt set gd=(case when @ee1=class then @ee || ',' || name else name end) ,
@ee=(case when @ee1=class then @ee || ',' || name else name end),
gdnum=(case when @ee1=class then @num+1 else 1 end),
@num=(case when @ee1=class then @num+1 else 1 end),@ee1=class;
select a.* from #tt a inner join
(select class,max(gdnum) as ma from #tt group by class) b
on a.class=b.class and a.gdnum=ma;
end

[cplovejavaee]

虽然结贴了,顺便问下Class 是什么

[wwwwb]

name 、Class表中的字段名，

[cplovejavaee]

...抱歉,我学Java的 ,Class被我当成关键字了..
谢谢了 解决了

[xing56788765]

为什么我的只拼接了两行呢？