title: Can we use SUM and Max Function with each other in SQL Statement?
body: <p>i have following requirements :</p>
  
  <pre>
  CODE         Marks  
  A             50  
  A             50  
  
  B             60  
  B             60  
  
  C             20  
  C             20  
  </pre>
  
  <p>Now , i want to write a query to display the CODE and Marks of top scorer. In this example its B and 120. how to write it in SQL.</p>