vb.net - 将多个数据合并为一个数据

Question

我有这样的数据

 CCSKIYEARDOULE     |    CCSKIYEAR
 ------------------------------------ 
 92-93              |     92 
 92-93              |     93
 94-95              |     94
 94-95              |     95
 96-97              |     97

但我想要这样的输出

 CCSKIYEARDOULE     |    CCSKIYEAR
 ------------------------------------ 
 92-93              |     92, 93
 94-95              |     94, 95
 96-97              |     97

我已经使用 group_concat，但出现错误“ORA-00904：“GROUP_CONCAT”：无效标识符”

这是我的代码

SELECT GROUP_CONCAT(CCSKIYEARDOUBLE), CCSKIYEAR FROM CCS2_TBL_KI2 GROUP BY CCSKIYEARDOUBLE ORDER BY CCSKIYEAR ASC;

标签： vb.netoracle

Answer 1

Below check below query 

create table CCSK
 (CCSKIYEARDOULE varchar2(10),
 CCSKIYEAR number);

 begin
 insert into CCSK values ('92-93',92);
 insert into CCSK values ('92-93',93);
 insert into CCSK values ('94-95',94);
 insert into CCSK values ('94-95',95);
 insert into CCSK values ('96-97',97);
end;



 select CCSKIYEARDOULE,listagg(CCSKIYEAR,',')
 from CCSK
 group by CCSKIYEARDOULE;