GROUP_CONCAT Metodu - Birden Fazla Satırı Birleştirebiliriz

Giriş

GROUP_CONCAT ile birden fazla satırı birleştirebiliriz.

Örnek

Şöyle yaparız

GROUP_CONCAT(
  DISTINCT CONCAT(tags.id,',',tags.displayName) 
  ORDER BY posts.id 
  SEPARATOR ';'
)

Örnek

Şöyle yaparız

SELECT employeeNumber, firstName, lastName,
  ( SELECT GROUP_CONCAT(DISTINCT CONCAT(firstName,lastName,employeeNumber) SEPARATOR ',') 
    FROM employees) AS concatted
FROM employees
INNER JOIN
 customers ON customers.salesRepEmployeeNumber = employeeNumber
GROUP BY employeeNumber
ORDER BY firstName , lastname;