+ 2

delete duplicate records

How to delete the duplicate records from a table?

27th Apr 2017, 4:56 AM
Ranendra Lakha
Ranendra Lakha - avatar
2 Answers
+ 4
follow the link. there some possibilities are described http://www.besttechtools.com/articles/article/sql-query-to-delete-duplicate-rows
27th Apr 2017, 6:07 AM
Oliver
+ 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.
27th Apr 2017, 6:23 AM
Kuba Siekierzyński
Kuba Siekierzyński - avatar