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

+2

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

+4

follow the link. there some possibilities are described http://www.besttechtools.com/articles/article/sql-query-to-delete-duplicate-rows

+4

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.