Hi,
I have a student table & has three coulumns. The sample data exists in this table as below.
I want a query which should output(please see in expected output). I don't want to use cursor.
Student table with sample row
StudenRowid Name course
1 paul Math
1 paul English
2 David science
2 David English
3 Tim Matk
Expected output:
Name course
Paul Math,English
David Science,English
Tim Math
Thanks for your help.
Open in new window