title: How to get the name of a the student who got max marks in each subject?
body: <p>I have the following table</p>
  
  <pre><code> Name  |  Subject  | Marks
   --------------------------
   a        M          20
   b        M          25  
   c        M          30
   d        C          44 
   e        C          45
   f        C          46 
   g        H          20
  </code></pre>
  
  <p>Here I have a "Student" table I want to get the Name of the student who got<br>
  Max marks from each subject from the student table like the following  OUTPUT.</p>
  
  <pre><code> Name | Subject | Marks  
   c        M        30
   f        c        46
   g        h        20
  </code></pre>