DELETE FROM Mytable WHERE RowID NOT IN (SELECT MIN(RowID) FROM Mytable GROUP BY Col1,Col2,Col3)

kaynak: http://www.codeproject.com/Articles/...-in-SQL-Server