I have a table that has had duplicates (that is rows with a key indexed field the same) added to it due to erroneously turning off a unique flag. Is there some neat/simple way to select all duplicates in one select ? TIA