Deleting duplicates

How can we delete duplicate rows in a table of way fast and safe?

It's easy, if our table own defined a identity field then:


Delete from table
Where identity_field not in ( SELECT MAX( identity_field) FROM table GROUP BY [field1],[field2]...)