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

http://knowitbasic.blogspot.com/2014/04/delete-duplicate-rows-using-rownumber.html