title: How do I specify the order of GROUP BY?
body: <p>How do I ensure, when I GROUP BY QID, that only the most recent row is returned?</p>
  
  <pre><code>ID, QID, VALUE, TIMESTAMP
  45,1,Male,1362044759
  58,1,Female,1362045122
  59,1,Male,1362045149
  60,1,Female,1362045153
  82,1,Female,1362045863
  83,1,Female,1362045887
  92,1,Male,1362046012
  101,1,Female, 1362046401
  
  SELECT ID, QID, VALUE, TIMESTAMP FROM table GROUP BY ID
  </code></pre>
  
  <p>...returns the first row. I can't simply do a LIMIT 1, as this is just an example, there are lots of QIDs in the table, which are all grouped.</p>
  
  <p>Thanks.</p>