title: How to DELETE duplicate records in sql
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1173963/how-to-delete-duplicate-rows-with-sql">How to delete duplicate rows with SQL?</a>  </p>
  </blockquote>
  
  
  
  <p>I have a table with records and I want to delete all duplicate records</p>
  
  <pre><code>DELETE FROM 'table'
  WHERE 'field' IN 
  (
  SELECT 'field' FROM 'table' GROUP BY 'field'
  HAVING (COUNT('field')&gt;1)
  )
  </code></pre>
  
  <p>Why isn't this working? </p>