使用CET和row_number()删除重复记录
在sql server 2005 和 2008中可以使用CET(通用表达式)和row_number()函数删除重复记录,代码:
WITH CTE (COl1,Col2, DuplicateCount) AS ( SELECT COl1,Col2, ROW_NUMBER() OVER(PARTITION BY COl1,Col2 ORDER BY Col1) AS DuplicateCount FROM DuplicateRcordTable ) DELETE FROM CTE WHERE DuplicateCount > 1 GO