Group Concatenation of Names
Medium
Date & String Functions
For each department return the employee names as a single comma-separated string in alphabetical order.
Table schema
Employees(id INT PRIMARY KEY, name VARCHAR(50), department_id INT)Sample data
id | name | department_id
1 | Zoe | 1
2 | Adam | 1
3 | Mia | 2
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.