title: Return more than one row when using MAX SQL
body: <p>I HAVE 2 TABLES IN MS SQL:</p>
  
  <p>table: Candidate<br>
  <code>CandidateId |PositionId</code><br>
  <code>1              1</code><br>
  <code>2              1</code><br>
  <code>3              1</code><br>
  <code>4              2</code><br>
  <code>5              2</code><br>
  <code>6              2</code></p>
  
  <p>table: Voting<br>
  <code>CandidateId |VoteCount</code><br>
  <code>1              8</code><br>
  <code>2              8</code><br>
  <code>3              4</code><br>
  <code>4              7</code><br>
  <code>5              6</code><br>
  <code>6              7</code></p>
  
  <p>AND I WANT TO RETURN A TABLE LIKE THIS<br>
  (returning the List of Candidates with Max VoteCount) </p>
  
  <p><code>CandidateId |PositionId |VoteCount</code><br>
  <code>1              1              8</code><br>
  <code>2              1              8</code><br>
  <code>4              2              7</code><br>
  <code>6              2              7</code> </p>
  
  <p>In case that more than one row have same MAX Vote Count it will show the 2 rows instead. I tried it many times but it always returns one row.
  Can you help me, what query can i use?</p>