Concatenate and group multiple rows in Oracle
- by user1693347
Suppose I have a table like this:
NAME GROUP
name1 groupA
name2 groupB
name5 groupC
name4 groupA
name3 groupC
I'd like to have a result like this:
GROUP NAMES
groupA name1,name4
groupB name2
groupC name3,name5
If there were only one column in the table, I could…