• Finding Duplicates using SQL

    by Venkata Koppaka | Jan 25, 2010

    Here is a handy script to find duplicates in a table using SQL -

    1 select column, 
    2     count(column) as numofoccurrences 
    3 from table 
    4 group by column 
    5 having count(column) > 1 

    Cheers,

    Venkata

    Go comment!