有表tb, 如下： id value ----- ------ 1 aa 1 bb 2 aaa 2 bbb 2 ccc 需要得到结果： id values ------ ----------- 1 aa,bb 2 aaa,bbb,ccc
是ASE还是ASA？ASA用LIST，前者用变量累加的方法
ASE, 能给个例子吗？sybase不支持自定义函数吗？
示例，自行修改 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;
