select distinct elements from two columns with comma separated in sql

Question

I have a table with two columns like this

col1     col2
 a        b
 b        a
 c        d
 d        a

I want to get distinct values of these two columns combined with comma separated. Expected out put is like this

a,b,c,d

possible duplicate of [SQL group\_concat function in SQL Server](http://stackoverflow.com/questions/8868604/sql-group-concat-function-in-sql-server) — , Nov 05 '13 at 12:44

Aleksandr Fedorenko · Accepted Answer · 2013-11-05T13:40:44.803

4

The following example concatenate row values into a variable

DECLARE @val nvarchar(max)
SELECT @val = COALESCE(@val + ',' + col1, col1)
FROM (SELECT col1
      FROM dbo.twoColumns
      UNION
      SELECT col2
      FROM dbo.twoColumns
      ) x
SELECT @val

Demo on SQLFiddle

edited Nov 05 '13 at 13:40

answered Nov 05 '13 at 13:29

Aleksandr Fedorenko

16,594
6
37
44

uvais · Answer 2 · 2013-11-06T08:15:03.443

2

try this , its very much easy i think

select group_concat(distinct(c)) as d
from 
(
  select col1 c from your_table
  union
  select col2 c from your_table
) as d

edited Nov 06 '13 at 08:15

answered Nov 05 '13 at 13:00

uvais

416
2
6

I get the data correclty by this method ,but is not comma seperated :( – None Nov 05 '13 at 13:06
`group_concat` is only valid in MySQL and the question is tagged as SQL Server. – Mosty Mostacho Dec 05 '13 at 20:49

select distinct elements from two columns with comma separated in sql

2 Answers2