title: how to remove duplicate values from MySQL table
body: <p>i am looking for the query, deletes the all duplicate values.</p>
  
  <pre><code>Example Table:
  
  1 ABC
  2 BBB
  3 DAC
  4 ABC
  5 AAA
  6 ABC
  
  output required
  
  1 ABC
  2 BBB
  3 DAC
  5 AAA
  </code></pre>
  
  <p>thanks for your help, i Google it can't find exact solution. </p>