title: mysql - need two limits?
body: <p>Given a table containing awards earned over several years by members of an organization that consists of multiple geographic districts, what mysql query would show the top award earner in each district?  I can easily get the top ten award earners across all districts with this query:</p>
  
  <pre><code>SELECT Membername,  count(Award)as Number FROM awards 
  GROUP BY Membername
  ORDER BY Number desc 
  LIMIT 10
  </code></pre>
  
  <p>But I need a list with the top earner for each district (there are about 90 of them), and I haven't gotten it right yet.</p>
  
  <p>I tried this:</p>
  
  <pre><code>SELECT Membername,  District, count(Award)as Number FROM awards 
  GROUP BY Membername, District
  ORDER BY Number desc, District 
  LIMIT 90
  </code></pre>
  
  <p>It has accurate counts for the members, but isn't showing one per district, so some districts show up more than once.  How do I get it to list the top earner per district, with each district showing up just once?  </p>