title: How to delete all but one row in SQL
body: <p>I would like to remove all but one row but in conjunction with PHP.</p>
  
  <p>I think it will be a simpler solution for my problem, which is to remove duplicate information. </p>
  
  <p>Ok... I just realised what i've already done is crap.</p>
  
  <p>Basically i have a table (dev_discs) and i want to search for duplicates in the column 'discReference' and then delete all but one, thus leaving the one remaining row. </p>
  
  <p>Is there an easy query to do this? I came across similar situations on the net and they're all complicated... I don't think its a very complicated scenario.</p>