Using the following code I could Get the number of counts for Duplicate records. But How do I delete the Duplicate entries, i.e I just want to keep the one single entry for my account Number, Preferebly the last one.

SELECT Accountno As Account_No,COUNT( * ) AS DupCount;
  FROM New_master ;
  INTO CURSOR Duplicates ;
  GROUP BY Accountno ;
  HAVING DupCount > 1 

I tried Select * from New_master UNION Select * from New_master . But It didn't worked.