title: SQL Select to make a value appear only once
body: <p>For those that have been helping me along the way with this twitter-clone, thank you!!  With your help, I've managed to get most things working and finally now to the last steps of the followers function.</p>
  
  <p>Right now, I have a dataset with the following fields: username, tweet, date</p>
  
  <p>An example of the data could look like:</p>
  
  <pre><code>Username    Tweet             Date
  kenny       hi!               2011-10-07 19:07:00
  stan        hello             2011-10-05 18:07:00
  kenny       looks like rain   2011-10-05 17:07:00
  stan        hello             2011-10-05 14:07:00
  cartman     authoritay!       2010-10-05 14:07:00
  </code></pre>
  
  <p>And I've been wrestling with the SQL statement that would produce a data set in which each user appears only once with their latest tweet.  So, based on the above, something that looks like this:</p>
  
  <pre><code>Username    Tweet             Date
  kenny       hi!               2011-10-07 19:07:00
  stan        hello             2011-10-05 18:07:00
  cartman     authoritay!       2010-10-05 14:07:00
  </code></pre>
  
  <p>I've been googling sql searches and have tried variations of COUNT, DISTINCT, MAX, but to no avail.  Any help would be greatly appreciated!  Thank you!</p>