[Stackoverflow] [Progress OpenEdge ABL] Progress 12.2 - Concat rows with same ID

Status
Not open for further replies.
J

JeromeF99

Guest
I use the database Progress 12.2 and I want to group rows with same id

For example I have

Code:
ID Code
1   PB
1   RO

And I want :

Code:
ID Code
1   PB, RO

This is my request :

Code:
SELECT id, code FROM table WHERE table.id = 1

I tried String_agg, Group_concat ... but nothing works. Anyone has an idea ?

Regards,

Continue reading...
 
Status
Not open for further replies.
Back
Top