Get distinct values from a column in a single comma separated string in sql?

I have a table that has rows that contains data for the same address from different sources-

What I want to achieve –

I am using snowflake.

>Solution :

ou can use listagg to achieve it.

If ou need a special order, you need to add following after the listagg

WITHIN GROUP (ORDER BY sortcolumn DESC)

The query without ordering is

SELECT
    RowID,  Address, listagg(Source, ', ')
FROM table1
GROUP BY RowID  Address