title: MySQL query: select records with highest value in group
body: <p>I have a MySQL table like this.</p>
  
  <pre><code>| season_id | round_1 | names  | score_round_1
  | 5         | 10      | John1  | 5  
  | 5         | 10      | John2  | 3
  | 5         | 11      | John3  | 2
  | 5         | 11      | John4  | 5
  </code></pre>
  
  <p>I want to select the records with highest score_round_1 in each round_1(10,11) group .</p>
  
  <p>In this case the first and last rows would be selected.</p>
  
  <p>I tried using the GROUP BY round_1 but that only returns the first row from the two. </p>
  
  <p>Any advice?</p>
  
  <p>Zolka</p>