Concatentate values for each id

Asked Apr 03 '12 at 16:00

Active Apr 03 '12 at 17:07

Viewed 56 times

Possible Duplicate:
Building a comma separated list?
Concatenate values based on ID
How to Comma separate multiple rows obtained from a SQL Query
Combing values of a column on multiple rows.?

I have tables like this:

ID Tag
1   abc
1   def
1   ghi
2   acf
2   klv

and I want this

ID Tag
1  abc, def, ghi
2  acf, klv

How this can be done?

Thanks.

edited May 23 '17 at 10:34

Community

asked Apr 03 '12 at 16:00

el ninho

4,183
15
56
77

6

Search SO - this question has been answered **at least A GAZILLION times** already..... – marc_s Apr 03 '12 at 16:02
@marc_s what GAZILLION stands for? – el ninho Apr 03 '12 at 16:03
1

@marc_s - I think it was asked more than that. – Oded Apr 03 '12 at 16:03
Seach [wiki](http://en.wikipedia.org/wiki/Indefinite_and_fictitious_numbers), GAZILLION, has been described there :) – Jamiec Apr 03 '12 at 16:04
1

@elninho - http://dictionary.reference.com/browse/gazillion – Oded Apr 03 '12 at 16:04
See: http://stackoverflow.com/questions/5536754/how-to-comma-separate-multiple-rows-obtained-from-a-sql-query or http://stackoverflow.com/questions/9471384/combing-values-of-a-column-on-multiple-rows or a great many more..... – marc_s Apr 03 '12 at 16:06
2

@elninho - Appologies, but this is one of those "once a day, at least" questions on SO. Can't help being a smartass *once in a while* – Jamiec Apr 03 '12 at 16:07
@Oded: I didn't want to exaggerate too much :-) – marc_s Apr 03 '12 at 16:09
It does get asked at least once per day – t-clausen.dk Apr 03 '12 at 19:41

Concatentate values for each id

0 Answers0