3 ms·
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
by gigatexal 4y ago
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