Is there a simple way to find all duplicate records for a certain set of fields in a table and then mark one field as duplicate to indicate them.

Or does one usually create some sort of cursor and handle it with indexes and record type processing?