title: How to select max marks from one subject and min marks from another subject in a student table?
body: <p>Select max marks from math subject and select min marks from physics subject.</p>
  
  <p>I can only think of it like following:</p>
  
  <pre><code>Select subject, max(Marks) as Max_Marks, MIN(Marks) as Min_Marks
  from Student 
  group by Subject
  </code></pre>
  
  <p>But above query shows max, min for each subject.</p>
  
  <p>Any other way to query this ?</p>