title: Deleting Records
body: <p>I have a table [user_logs] with the following fields [username], [datetimelog]</p>
  
  <p>Sample Data</p>
  
  <pre><code>==============
  user1   2011-06-28 08:49:01
  user2   2011-06-28 08:59:38
  user3   2011-06-28 09:04:31
  user4   2011-06-28 10:00:15
  user2   2011-06-28 10:28:54
  user1   2011-06-29 08:31:22
  user9   2011-06-29 08:32:32
  user2   2011-06-29 10:13:53
  user1   2011-06-29 13:11:15
  </code></pre>
  
  <p>I want to know how to create an SQL Delete query to delete all user logs EXCEPT their last log so that the above example will produce the following after a DELETE query</p>
  
  <pre><code>user1   2011-06-29 13:11:15
  user2   2011-06-29 10:13:53
  user3   2011-06-28 09:04:31
  user4   2011-06-28 10:00:15
  user9   2011-06-29 08:32:32
  </code></pre>