techmixing.com
Deleting Duplicate rows using CTE - Technology with Vivek Johari
This article deleting duplicate rows using CTE shows how we can remove the duplicate rows using CTE feature of SQL Server