convert above table to below talbe in sql query

 StudentID Mark

1 10

1 20

1 30

2 40

2 50

2 60

3 70

3 80

3 90

StudentIDS Marks

1 10,20,30

2 40,50,60

3 70,80,90


convert above table to below talbe in sql query


SELECT StudentID, GROUP_CONCAT(Mark) AS Marks

FROM original_table

GROUP BY StudentID;


No comments:

Post a Comment

sun dried potato procedure

  Sun-Dried Potato Chips Recipe  https://www.youtube.com/watch?v=e_PVvAU77Qs , recipe for potato sun dried chips 1) ist peel off the potato ...