Finding duplicates with SQL?
Suppose Col1 is the field name for which you want to find duplicates:
Select Col1, Count(Col1) as count
from table1
group by Col1
having Count(Col1) > 1
Suppose Col1 is the field name for which you want to find duplicates:
Select Col1, Count(Col1) as count
from table1
group by Col1
having Count(Col1) > 1
