I think ROWID is a good candidate when you want to delete duplicate rows from a table.

- Rajeev