I have below data
I want to find distinct duplicate values of one column and add unique values to another column with a comma.
Asked
Active
Viewed 29 times
0
-
Please click one example to view my required output. – satputenandkumar May 20 '16 at 05:50
-
Dear sir, I am new in slq so i am not getting solution – satputenandkumar May 20 '16 at 05:55
-
select col1, stuff( ( SELECT DISTINCT ',' + col2 FROM table WHERE [col1] = a.[col1] FOR XML PATH ('')),1,1,'')AS col2 FROM table AS a GROUP BY col1 – Antony May 20 '16 at 06:19
-
Thank You Antony Sir It works nice. Thanks again. :) – satputenandkumar May 20 '16 at 06:47