Delete duplicate records

;WITH NEW

AS




(


SELECT *,ROW_NUMBER() OVER(PARTITION BY column1 ORDER BY column2 DESC) AS [Rank] FROM tablename




)


DELETE FROM NEW WHERE [Rank]=2