0

I am having table contains below records

Create Table Student_Marks(Student_Id int,Student_Mark int)

Insert into Student_Marks Values(1,50)

Insert into Student_Marks Values(2,60)

Insert into Student_Marks Values(1,40)

Insert into Student_Marks Values(2,70)

Insert into Student_Marks Values(1,60)

Insert into Student_Marks Values(2,90)

Required Output

Student_id  Student_Mark
1           50,40,60
2           60,70,90

i need a query and that query should contains group by clause also for another purpose.so please suggest a query.

Thom A
  • 88,727
  • 11
  • 45
  • 75
Ram
  • 727
  • 2
  • 16
  • 33

0 Answers0