title: MySQL Group by UserID only show last post?
body: <p>I'm trying to show a list with the last posts from each user. If I group by ID however I get the first post instead of the last. How can I group by UID and show only the row with the biggest <code>Date</code>?</p>
  
  <p>This is what I'm trying now:</p>
  
  <pre><code>SELECT * FROM Posts GROUP BY `UID` ORDER BY `Date` DESC
  </code></pre>