将多个数据合并为一个数据

2023-12-27

我有这样的数据

 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;

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;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

将多个数据合并为一个数据 的相关文章

随机推荐