Hi Folks,
Can you please help me with the below query:
Master Data:
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Result Data:
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Please help
Can you please help me with the below query:
Master Data:
Username | Subject | Score |
A1 | English | 50 |
A1 | Maths | 45 |
A1 | Physics | 34 |
A1 | History | 23 |
A1 | Geography | 56 |
A2 | English | 24 |
A2 | Maths | 67 |
A2 | Physics | 45 |
A2 | History | 32 |
A3 | English | 67 |
A3 | Maths | 89 |
A3 | Physics | 65 |
A3 | History | 75 |
A3 | Geography | 72 |
A4 | Maths | 45 |
A4 | Physics | 25 |
A4 | History | 67 |
A4 | Geography | 45 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Result Data:
Username | History | Physics | Geography | Maths | English |
A1 | |||||
A2 | |||||
A3 | |||||
A4 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Please help