;WITH CETAS (SELECT *, ROW_NUMBER() OVER (PARTITION BY SearchTask_PKID ORDER BY SearchTask_PKID) RowNo FROM [SiteAnalysis].[dbo].[UrlQueue] ) DELETE CET WHERE RowNo > 1
sql 去重
原文：http://www.cnblogs.com/wolf12/p/4651612.html
