title: Removing duplicates from SQL results
body: <p>I'm having trouble trying to retrieve data from mySQL table.  The table holds all the lap times from a racing event by all the participants.  The table has multiple entries for each race.  I would like to select each participant's best lap time, however I'm not sure how to get rid each participant's duplicates.</p>
  
  <p>I've tried the following statement.</p>
  
  <pre><code>SELECT *
  FROM   laptimes
  GROUP  BY laptime,
            username 
  </code></pre>
  
  <p>The table looks like this:</p>
  
  <pre><code>lap username    laptime
  2   Blackvault  1200.000    
  1   Blackvault  1234.000    
  3   Elmo        1235.000    
  </code></pre>
  
  <p>I'd like to display only lap 2 of Blackvault and Elmo's only lap.
  The SQL will need to be generic as there could be N number of racers and N number laps.</p>
  
  <p>Any help is appreciated.</p>