Post reply

Finding Duplicates

  • August 8, 2002 at 9:38 am

    #158288

    How can I use SQL to check for duplicate entries in a column?

  • August 8, 2002 at 10:12 am

    #434283

    SELECT [fieldName], COUNT([fieldName]) AS nDup

    FROM [tableName]

    GROUP BY [fieldName]

    HAVING (COUNT([fieldName] > 1)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply