I know there are many ways to delete duplicate records to table, but some times we find that there is no column to identity each record like Identity or any PK.
So handle this requirement , I think CTE is best option here..
Create Table Product
Insert Into Product
Select *,'Before' from Product;
WITH CTE (ID,Product,Price)
Select ROW_Number () OVER(Partition By Product Order By Product) AS ID,*
Where ID >1;
Here Row_Numer function generates unique number for each partition and then we can simply delete the records having ID value > 1 and solve our problem.