title: Obtaining a winner from a table using a query
body: <p>I have created a voting application in Borlands Delphi 7 that registers votes and updates an access table
  My access table consists of two columns, column 1 is the candidate's name, and column 2 is the number of votes he/she has obtained</p>
  
  <p><strong>What would the SQL statement be if I wanted to obtain the candidate(s) with the most votes?</strong></p>
  
  <p>I have tried </p>
  
  <pre><code>SELECT Max(Candidate.[Candidate Name]) AS [MaxOfCandidate Name], Max(Candidate.[Number of  Votes]) AS [MaxOfNumber of  Votes]
  FROM Candidate
  
  ;
  </code></pre>
  
  <p>But this one returns one value and therefore if there are 2 or more candidates with the same amount of votes only the first name will be displayed.</p>