Take the following table:

I need a T-SQL to give me distinct Values in the Products Column

Required Result as below:

CodePudding user response：

use STRING_SPLIT,distinct and string_agg as follows

SELECT ID,
       String_agg(value, ',') AS Products
FROM   (SELECT DISTINCT ID,
                        value
        FROM   (SELECT ID,
                       a.value
                FROM   table
                       CROSS apply String_split(products, ',') a) b) c
GROUP  BY ID