Delete duplicate rows using Row_number and CTE in SQL
knowitbasic.blogspot.com