MySQL - Show combined columns using Group By

Asked Jul 01 '21 at 02:57

Active Jul 01 '21 at 02:57

Viewed 22 times

I've the following data in my SQL table (SubjRecord)

Subject | Email

What should the SQL statement be like if I want the result to be:

English,Maths,Science | xyz@mail.com

Thanks in advance.

asked Jul 01 '21 at 02:57

Chiang