1SELECT GROUP_CONCAT(DISTINCT categories ORDER BY categories ASC SEPARATOR ' ') FROM table
2
1mysql> select Id,group_concat(Name SEPARATOR ',') as GroupConcatDemo from GroupConcatenateDemo
2 -> group by Id;
1SELECT emp_id, fname, lname, dept_id,
2GROUP_CONCAT ( strength ) as "strengths"
3FROM employee group by emp_id;
4