Skip
Arish's avatar

163. GROUP_CONCAT Function


GROUP_CONCAT

Combines values into a single string.

sql
1SELECT course, GROUP_CONCAT(name) AS students
2FROM students
3GROUP BY course;
coursestudents
PythonAlice,Bob,Carol
RubyDavid,Eve