I made this function in order to obtain listagg functionality when querying an SQL database at work, but only concatenate distinct values. I've found it to be very helpful. By default it inserts ", " ...

SQL is a powerful tool for BI analysis, as it allows you to manipulate, transform, and combine data from different sources. One of the functions that you can use to perform these tasks is CONCAT ...