我有这样的数据
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(使用前将#替换为@)