Click here to Skip to main content
15,881,715 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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;
Posted
Updated 23-May-18 0:29am

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900