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

Asked Aug 27 '15 at 15:06

Active Aug 27 '15 at 15:06

Viewed 29 times

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?

asked Aug 27 '15 at 15:06

Lago

2

possible duplicate of [Concatenate many rows into a single text string?](http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string) – Juan Carlos Oropeza Aug 27 '15 at 15:07
It looks like you've duplicated this, which may help. http://stackoverflow.com/questions/15154644/group-by-to-combine-concat-a-column – Russ Sands Aug 27 '15 at 15:11

0 Answers0