title: MySQL check if MAX value has duplicates
body: <p>I'm running contests on my website. Every contest could have multiple entries. I want to retrieve if only the MAX value of votes has a duplicate.</p>
  
  <p>The table is as follows:</p>
  
  <pre><code>contest_id    entry_id    votes
  1             1           50
  1             2           34
  1             3           50
  2             4           20
  2             5           55
  3             6           53
  </code></pre>
  
  <p>I just need the query to show me that contest 1 has a duplicate MAX value without additional information.</p>
  
  <p>I tried this but didn't work:</p>
  
  <pre><code>SELECT MAX(votes) from contest group by contest_id having count(votes) &gt; 1
  </code></pre>