Oracle SQL put values of a column in one row

Question

I have a query were im returning a 3 columns

ID    NUMBER    LETTER
123    1        a
124    2        b
123    1        c
123    1        d

what I want to do is have a row like

ID    NUMBER    LETTER
123    1        a,c,d

when I the ID and NUMBER column is the same is one value and t

Taryn · Accepted Answer · 2013-06-21 16:11:59Z

3

In Oracle 11g, you can use the LISTAGG() function:

select id,
  number,
  listagg(letter, ', ') within group(order by id, number) as letter
from yourtable
group by id, number;

answered Jun 21, 2013 at 16:06

Taryn

249k57 gold badges374 silver badges409 bronze badges

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

1 Answer 1