title: SQL Query to find winners within a contest
body: <p>I have a query which returns to me results as follows:</p>
  
  <pre><code>  Race   | Candidate | Total Votes | MaxNoOfWinners
      ---------------------------------------------------
      1      | 1         | 5000        | 3
      1      | 2         | 6700        | 3
      2      | 1         | 100         | 3
      2      | 2         | 200         | 3
      2      | 3         | 300         | 3
      2      | 4         | 400         | 3
      ...
  </code></pre>
  
  <p>I was wondering if there was a query that could be written to return only the winners (based on the MaxNoOfWinners and TotalVotes) for a certain race. So for the above i would only get back</p>
  
  <pre><code>Race   | Candidate | Total Votes | MaxNoOfWinners
  ---------------------------------------------------
  1      | 1         | 5000        | 3
  1      | 2         | 6700        | 3
  2      | 2         | 200         | 3
  2      | 3         | 300         | 3
  2      | 4         | 400         | 3
  ...
  </code></pre>