How to use GROUP_CONCAT with different SEPARATOR in MySQL?
SELECT id, GROUP_CONCAT(department SEPARATOR ' ') AS department FROM employee group by id;
BY Best Interview Question ON 12 Nov 2019
SELECT id, GROUP_CONCAT(department SEPARATOR ' ') AS department FROM employee group by id;