code name value
1 aaa 15
2 bbb 18
1 aaa 17
1 aaa 16
I need select items group by code. Result must be:
1 aaa 15,17,16
2 bbb 18
Asked
Active
Viewed 34 times
-2
user2759163
- 1
- 1
- 3
-
Which SQL Server version? – jarlh Jan 18 '21 at 12:48
-
it is MS Sql Server 2012 – user2759163 Jan 18 '21 at 12:54
-
https://stackoverflow.com/questions/194852/how-to-concatenate-text-from-multiple-rows-into-a-single-text-string-in-sql-serv – jarlh Jan 18 '21 at 13:03
2 Answers
0
You need string_agg as follows:
Select code, name,
String_agg(value,',') within group (order by value) as val
From t
Group by code, name
Popeye
- 34,995
- 4
- 9
- 31
0
If you have a maximum of two values, you can use aggregation:
select code, name,
(case when count(*) > 1 then concat(min(value), ',', max(value))
else min(value)
end)
from t
group by code, name;
Gordon Linoff
- 1,198,228
- 53
- 572
- 709