title: MySQL delete duplicate records but keep latest
body: <p>I have unique <code>id</code> and <code>email</code> fields. Emails get duplicated. I only want to keep one Email address of all the duplicates but with the latest <code>id</code> (the last inserted record).</p>
  
  <p>How can I achieve this?</p>