How to get the maximum mark of the repeating field from this sql table using a query.

I can better describe the problem here.. 
The sample database table that consists of results is present as follows...
Student ID      Subject Code   Subject Name     Internal Marks     External Marks     Total        Reg/Supp   Result   Year 11M91A0528             51006          C&DS                  15                                    17                32                 Supp       Fail         1 11M91A0528             51002            M1               &nb ...