Tuesday, October 13, 2009

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

No comments:

Post a Comment