Oracle string aggregation in group by

Question

I have formed a large query which fetches a large data set with the below data condition.

Column1 Column2  
M1        OTH  
M1        HHM  
M1        RES  
M2        HHM  
M2        RES  
M3        OTH  
M3        RES

I need to form it as:

M1        OTH,HHM,RES  
M2        HHM,RES  
M3        OTH,RES

Any help would be appreciated.

vc 74 · Accepted Answer · 2014-10-17 11:12:21Z

2

You can use one of the available string aggregation techniques described in this document.

For instance:

SELECT COLUMN1, LISTAGG(COLUMN2, ',') WITHIN GROUP (ORDER BY COLUMN1) AS COLUMN2s
FROM TABLE
GROUP BY COLUMN1;

answered Oct 17, 2014 at 11:12

vc 74

38.3k7 gold badges80 silver badges96 bronze badges

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

1 Answer 1