title: MySQL : Get max values of groups
body: <p>I have a table:</p>
  
  <pre><code>user_id | fav_song_genre | votes_as_fav_member
  --------+----------------+--------------------
        1 | hip hop        | 3
        2 | hip hop        | 5
        3 | rock           | 8
        4 | rock           | 6
  </code></pre>
  
  <p>How do I get only results of user_id's with the highest votes_as_fav_member per group fav_song_genre:</p>
  
  <p>Something like</p>
  
  <pre><code>SELECT *, MAX(votes_as_fav_member) as most_votes 
  FROM   table 
  GROUP BY 
         fav_song_genre
  </code></pre>
  
  <p>I'm using that but it's not giving me the ID's of the members with most votes per genre.</p>