It's a common operation in DB to have a need of grouping and concatenating several columns in the output result of the query. For example if you want to get make an report for people based on their country from a table containing both the country and the person:

Example 1

On the left is the table and on the right is the concatenated output:

Example 2

On the left if the table that will be queried and on the right is the ouput result.

Oracle group concatenate

This is the oracle version of group concatenation by using the LISTAGG function. As you can see from the code below two things has to be given : the grouping column and the concatenating one.

SELECT country,
  LISTAGG(person, ', ') WITHIN GROUP (
ORDER BY person) "names"
FROM mytable
GROUP BY country;

MySQL concat and group

The mysql version is much simpler by using function GROUP_CONCAT and the example is self-explantory.

SELECT country, GROUP_CONCAT(person) FROM mytable GROUP BY country