将许多数据合并为一个数据 [英] Merge many data as one data

问题描述

我有这样的数据



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来自CCS2_TBL_KI2 GROUP by CCSKIYEARDOUBLE ORDER by CCSKIYEAR ASC;

I have data like this

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

But I want the output like this

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

I already use the group_concat, but I got an error "ORA-00904: "GROUP_CONCAT": invalid identifier"

What I have tried:

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

推荐答案

你在这里得到了答案： vb.net - 将许多数据合并为一个数据 - Stack Overflow [ ^ ]

You've got an answer here: vb.net - Merge many data as one data - Stack Overflow[^]

这篇关于将许多数据合并为一个数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！