I have a list of student names and their grades.

To print a comma-separated list of student names in a specific grade, you can use SQL query logic. Here's an example query that retrieves the student names for a given grade and formats them as a comma-separated list:

SELECT STRING_AGG(StdName, ',') AS StudentList
FROM Student
WHERE Grade = 

Replace with the grade for which you want to generate the comma-separated list. This query uses the STRING_AGG function to concatenate the StdName values with commas as the separator.

For instance, if you want to retrieve the student names for Grade 1, you would use the following query:

SELECT STRING_AGG(StdName, ',') AS StudentList
FROM Student
WHERE Grade = 1

The result of the query will be a single row containing a column named StudentList that holds the comma-separated list of student names for the specified grade.

Note that the STRING_AGG function may not be available in all database systems. If you're using a different database, consult the documentation for your specific database to find the appropriate function or method for aggregating string values.

SELECT
  Grade,
  STUFF((
    SELECT ', ' + StdName
    FROM Student
    WHERE Grade = S.Grade
    FOR XML PATH('')
  ), 1, 2, '') AS StudentList
FROM Student AS S
GROUP BY Grade;

Hi Rajeev

To print a comma-separated list of student names in a specific grade from the given Student table, you can use SQL query syntax. Here's an example query that achieves this:

SELECT GROUP_CONCAT(StdName SEPARATOR ', ') AS StudentList
FROM Student
WHERE Grade = [desired_grade]

Replace [desired_grade] with the grade number you want to retrieve the student names for.

For instance, if you want to print the comma-separated list of student names for grade 2, the query will be:

SELECT GROUP_CONCAT(StdName SEPARATOR ', ') AS StudentList
FROM Student
WHERE Grade = 2