SELECT id, GROUP_CONCAT(department SEPARATOR ' ') AS department FROM employee group by id;

BY Best Interview Question ON 12 Nov 2019