将许多数据合并为一个数据 [英] 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屋!