sql query for deleting duplicate rows or records in sql query

Sql query for removing duplicate records or rows from table in sql query.




WITH

Test AS (SELECT ROW_NUMBER () OVER ( PARTITION BY website ORDER BY website) AS A FROM tbladdwebsite ) delete FROM Test WHERE A > 1