Sql query to combine multiple rows

Question

I have a table as follows

I want to have the following table, seems like easy but i have no clue how to deal with it.

Any suggestions are very much appreciated!

Stefano Zanini · Accepted Answer · 2017-03-31 09:23:02Z

3

I think this would suffice

select  distinct Customers, Items
from    YourTable

answered Mar 31, 2017 at 9:23

Stefano Zanini

5,9362 gold badges15 silver badges33 bronze badges

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

1 Comment

Thanks Stefano, I was thinking too complex :)

G.Ashok Kumar · Accepted Answer · 2017-03-31 09:33:37Z

1

From Oracle 11gR2, the LISTAGG clause should do the trick:

SELECT customers,
       LISTAGG(items, ',') WITHIN GROUP (ORDER BY items)
FROM YOUR_TABLE
GROUP BY customers;

try this, it might work

you can also wm_concat

SELECT customers, wm_concat(items) as item
FROM   table
GROUP BY customers;

it might also work

for my sql,

select  distinct customers, items from tablename

answered Mar 31, 2017 at 9:23

G.Ashok Kumar

1,6332 gold badges15 silver badges25 bronze badges

the last one wins the race, its simple and i didnt got this idea :) I was thinking too complex. thanks Ashok