title: SQL SELECT MAX COUNT
body: <p>I have three columns in a table: id, streetname, count. To some ids is more than one streetname assinged. Count tells how often the respective street is assigned to the id. How can I get just the id and the streetname with the highest count.</p>
  
  <p>Example table:</p>
  
  <pre><code>id     streetname     count
  1      street1        80
  1      street2        60
  1      street3        5
  2      street4        10
  2      street5        6
  </code></pre>
  
  <p>Result should be like this:</p>
  
  <pre><code>id     streetname
  1      street1
  2      street4
  </code></pre>
  
  <p>Thanks in advance!</p>