Hello everyone,
I have used listagg() as below :
select
listagg( field1, ',')
within group (order by field1) as field1,
listagg(field13, ',')
within group (order by field13) as field13,
listagg(field4, ',')
within group (order by field4) as field4,
listagg(field7, ',')
within group (order by field7) as field7,
listagg(field9, ',')
within group (order by field9) as field9,
listagg(field8, ',')
within group (order by field8) as field8,
listagg(field15, ',')
within group (order by field15) as field15
from shp_load_match_tb where field6='668972051854' and customer_code='GLID'
group by field6;
This query is getting the csv of all column values but what we need is to get csv of unique column values. Can anyone suggest what can we do to make it better.