title: Group by selects first occurence of field how can I get the last one?
body: <pre><code>SELECT user_id, created FROM photo_comments GROUP BY user_id
  </code></pre>
  
  <p>returns </p>
  
  <pre><code>  user_id  created  
    1        2009-10-20 21:08:22 
    12       2009-10-20 21:45:00 
    16       2009-10-28 20:35:30 
  </code></pre>
  
  <p>But that created date of 2009-10-20 for user id 1 is the first entry by user id 1. </p>
  
  <p>How can I get the last entry by user id 1? (date should be 2009-11-02)</p>
  
  <p>I'm trying to get the last entry by each user in order of most recent first.</p>