Mysql:How to concatenate more than one row into single row with diffrent field name?
- by subakaran
id Subject mark Year
1 Maths 32 2008
1 Science 40 2009
1 Science 45 2008
1 English 50 2009
1 English 60 2008
I need solution like this
ID Maths Science English
1 32 40 & 45 50 & 60
Please advise me. am using my sql
