title: What is a efficient way to delete the most recent X record from SQL?
body: <p>I have a simple table where one of the field is a date column. I can select the most recent X records by doing </p>
  
  <pre><code>Select * from MyTable order by last_update desc limit X
  </code></pre>
  
  <p>But how do I efficiently delete those column? Is subselect the quickest?</p>