Pls help me, thank you!

  • 12 years ago

    Hi all,         

    I have a table which contain Course and student.

    eg: Student    Course      

          A            Arts          

          B           Maths         

          C           Maths        

          D           Arts            

    I need to write a query which returns the follwing data

    Course          Student

    Maths           B,C

    Arts              A,D

    Please help me if anybody have any idea.

    Thank you very much in advance

  • 12 years ago

    Answered in the Sql Server section


Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“I have always wished for my computer to be as easy to use as my telephone; my wish has come true because I can no longer figure out how to use my telephone” - Bjarne Stroustrup