SyncBASE interview question

How to delete the duplicate entries in the SQL table

Interview Answer

Anonymous

24 Mar 2016

SELECT the DISTINCT records into a New Table TRUNCATE the Old Table MERGE the New Table back into the Old Table