[gigatexal]

I use this all the time to find dups:

Select pk columns + count(column that might have dups) From table Group by pk Having count(*) > 1