jeudi 27 août 2015

How to list rows which has the same value in the first column but different in the second? (SQL)

I have a Data table like this:

Name        Grade
Jim          5
Jim          4
Charlie      3

I would like to get another Result table like this:

Name        Grades
Jim          5,4
Charlie      3

How can I list or sort out the grades of a child in one column?

Aucun commentaire:

Enregistrer un commentaire