DELETE FROM dbo.article WHERE ID NOT IN (SELECT minid FROM (SELECT title,MIN(ID) AS minid FROM dbo.article GROUP BY title) a)
转载于:https://www.cnblogs.com/baixingfa/archive/2009/01/19/1378345.html
转载于:https://www.cnblogs.com/baixingfa/archive/2009/01/19/1378345.html