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 ", " ...

Learn what CONCAT is, why you should use it, and how to use it in SQL for BI analysis. See examples of how to join or link together strings or columns with CONCAT.