title: Mysql Duplicate Rows ( Duplicate detected using 2 columns )
body: <p>How to remove duplicated in this setup?</p>
  
  <pre><code>id    A       B 
  ----------------
  1     apple   2  
  2     orange  1       
  3     apple   2   
  4     apple   1 
  </code></pre>
  
  <p>In here I want to remove (apple,2) which occurs twice. The id numbers are unique. I would use DISTINCT keyword if it were not. Can I some how make a key out of columns A and B and then use the DISTINCT keyword on that to get what I need ? Many thanks for your replies. </p>