I am having a heckuva time trying to find duplicates in a client's table. It seems that they've had some corruption in their database as well, so I used VALIDATE DATABASE, which gave me a clue that their primary key wasn't in synch with referential integrity.

Isn't there a simple SQL statement I can use to find the dupes? This table is huge.