title: mysql only max of count with several max
body: <p>I am looking for a query, getting only the biggest one's.</p>
  
  <pre><code>SELECT results.playerid, 
         username, 
         Count(*) AS count 
  FROM   results 
         LEFT JOIN players 
                ON results.playerid = players.playerid 
  WHERE  points = 5 
  GROUP  BY playerid 
  ORDER  BY count DESC 
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>+-----------+-----------+-------+
  | playerID  | username  | count |
  +-----------+-----------+-------+
  | 1         | Lorem     | 2     |
  | 2         | Ipsum     | 2     |
  | 3         | Dolor     | 1     |
  +-----------+-----------+-------+
  </code></pre>
  
  <p>Expected Output:</p>
  
  <pre><code>+-----------+-----------+-------+
  | playerID  | username  | count |
  +-----------+-----------+-------+
  | 1         | Lorem     | 2     |
  | 2         | Ipsum     | 2     |
  +-----------+-----------+-------+
  </code></pre>
  
  <p>Would be no problem if there would be only one biggest.</p>
  
  <p>Any tips?</p>
  
  <p><strong>Fiddle: <a href="http://sqlfiddle.com/#!9/7c74c17/1" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/7c74c17/1</a></strong></p>