delete duplicate records | SoloLearn: Learn to code for FREE!


delete duplicate records

How to delete the duplicate records from a table?

4/27/2017 4:56:04 AM

Ranendra Lakha

2 Answers

New Answer


follow the link. there some possibilities are described


You want to actually ALTER the table or just display the unique records only? For the former, you may take Oliver's suggestions. For the latter SELECT DISTINCT should do the trick.