Sololearn: Learn to Code
New course! Every coder should learn Generative AI!
Try a free lesson
+ 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