MySQL – Grouping by Multiple Columns to Single Column as A String
- by Pinal Dave
In this post titled SQL SERVER – Grouping by Multiple Columns to Single Column as A String we have seen how to group multiple column data in comma separate values in a single row grouping by another column by using FOR XML clause.
In this post we will see how we can produce the same result using the GROUP_CONCAT function in MySQL.
Let us create the…