How to concate column values in group rows in mysql

Sometime we face the problems for concatenating of group rows column value in a single string.
Scenario is like this :
We have a table data Like

now we want result like this :

How we can achieve concatenating of group by rows value.

GROUP_CONCAT() is a function by which we can concate group rows values.

For getting above result, we have to write query as follows

Please see here for More details

You Might Interested In