title: MAX (SUM(votes)) | get only winners
body: <p>I want to get only winners in mysql table.</p>
  
  <pre><code>SELECT mayor_id, local_unit_id, Value FROM 
     (SELECT mayor_id,  local_unit_id, SUM(  `votes` ) AS  'Value' 
      FROM mayorresults 
      GROUP BY  `mayor_id`) AS t1
      ORDER BY  `t1`.`local_unit_id` ASC
  </code></pre>
  
  <p>Idea is to Sum votes first then get only largest number, in this case the winner. </p>
  
  <p>With this query I can get all, but not just the winners.</p>
  
  <p>I want MAX(SUM(votes)) to get, but It doesn't work like this.</p>
  
  <p>EDIT: I want to get winners for each localunit</p>
  
  <p>eg.</p>
  
  <pre><code>local_unit_id    mayor_id    votes
   1                25          8562
   2                534         18562
  </code></pre>