title: How to delete duplicates on a MySQL table?
body: <p>I need to <code>DELETE</code> duplicated rows for specified sid on a <strong><code>MySQL</code></strong> table.</p>
  
  <p>How can I do this with an SQL query?</p>
  
  <pre><code>DELETE (DUPLICATED TITLES) FROM table WHERE SID = "1"
  </code></pre>
  
  <p>Something like this, but I don't know how to do it.</p>