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

React -1 ( react with ravenndra kanchi)

 react with tool chanis 45 to 50 sessions core  after 50 sessions -> some tooll chains == react with type script mern stackaplication in ...