How to restructure sql table from table1 to table 2 like this.

Question

question

prntcena asked Apr 17, '20

Table1 is like this

Id Name Subject

1 Rakesh English

1 Rakesh Maths

1 Rakesh Science

2 Mukesh English

2 Mukesh Maths

Table 2 which I want is like this:

Id Name Subject

1 Rakesh English, Maths, Science

2 Mukesh English, Maths

sql database mysql join

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-04-17T12:57:36Z

Kev Riley answered Apr 17, '20

If you are using SQL 2017 or newer, you can use the STRING_AGG() function

select
	id, [name],
	string_agg(Subject,',') as [subject]
from Table1
group by
 id, Name

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.