rohitnair
Mar 22, 2019Copper Contributor
Removing Duplicates on a primary key-less table
Hi,
I tried to remove duplicates from a table which contains a primary key. It seems there are various ways to tackle this situation. I tried using CTE (Common Table Expressions) and Row_Number function as well as inner join and it worked. It also works with use of distinct records on temporary table. But what if there is no primary key nor any business key which uniquely identifies a record? What if the id is same but other values are different in a record?
id name skill
1 vic DBA
1 vic DBA
2 Sam HR
2 Sam Marketing
Please suggest the optimal solution for the issue mentioned above.