STRING_AGG Function in SQL Server

This function is introduced in SQL Server 2017 (14x) concatenates the values of string expressions and places separator values between them. The separator is not added at the end of the string.

For practice, use the dataset below. Each student is assigned three subjects. One input per student is required, with all of his chosen subjects listed in a single row separated by a comma.

Implementation:
SELECT  StudentName,
              STRING_AGG(Subjects,’,’) Subjects
FROM tbStudentInfo
GROUP BY
    StudentName;

Result:

Hope you find this article helpful.

Please subscribe for more interesting updates.