Dear Sir/Ma'm,

Hope this is the easiest method for deleting the duplicate records. Please go through this query:

SET ROWCOUNT 1

DELETE temp1 FROM temp1...