Hello
I have below requirement where i need to concatenate column values for common names. Can you please suggest.
with t1
as
(
select 'SK' Name, 'reading' activity from dual
UNION ALL
select 'SK', 'writing' activity from dual
UNION ALL
select 'NK', 'Soccer' activity from dual
UNION ALL
select 'TK', 'golf' activity from dual
UNION ALL
select 'TK', 'Printing' from dual
UNION ALL
select 'TK', 'copying' from dual
)
select * from t1;
expecting below output.
NAME Activities
---------------------
SK reading, writing
NK Soccer
TK golf, Printing, copying
Thanks for your time.