oracle sql how combine column string value

Question

i have records

id | key | string column
------------------------
1  | 1   | A
------------------------
1  | 1   | B
------------------------
1  | 1   | C

i want result like below

id | key | string column
------------------------
1  | 1   | A, B, C
------------------------

someone know how to do? thank you

Gordon Linoff · Accepted Answer · 2020-06-17 13:38:58Z

1

You are looking for listagg():

select id, key, listagg(string, ', ') within group (order by string)
from t
group by id, key;

answered Jun 17, 2020 at 13:38

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1