Concatenating Multiple Rows in SQL

Question

I have a table structure that looks like this:

ID   String
-----------
1     A
1     Test
1     String
2     Dear
2     Person

I need the final output to look like this:

ID  FullString
--------------------
1   A, Test, String
2   Dear, Person

I am really lost on how to approach this... I looked on a couple examples online but they seemed to be VERY complex... this seems like it should be a real easy problem to solve in sql.

Thank you for all assistance!

possible duplicate of stackoverflow.com/questions/149772/… — OMG Ponies
– OMG Ponies, Commented Apr 28, 2010 at 18:49

Larry Lustig · Accepted Answer · 2010-04-28 18:56:09Z

0

 SELECT ID, GROUP_CONCAT(String) AS FullString
     FROM TABLE
     GROUP BY ID

There are additional parameters available for GROUP_CONCAT to control sequence and separation. GROUP_CONCAT is MySQL specific.

answered Apr 28, 2010 at 18:56

Larry Lustig

51.2k16 gold badges119 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Concatenating Multiple Rows in SQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related