I have a table with the following fields:

city
state
county
territory

There are several thousand records. I want to get rid of all of the duplicates; Just have one record for each unique record.

Does anyone have an example of code that would go through the table and mark all but one of all duplicate records for deletion?