>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.
If the primary key is called MyPrimary, I would use something like this:
select MyPrimary, count(*) as HowMany;
from MyTable;
group by MyPrimary;
having HowMany > 1
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)