Home Forums SQL Server 2005 Development Delete Duplicates from table with no identity column RE: Delete Duplicates from table with no identity column

  • September 25, 2009 at 6:46 am

    #1058426

    How about:

    SELECT dupeColumn,

    COUNT(dupeColumn) AS NumOccurrences

    FROM users

    GROUP BY dupeColumn

    HAVING ( COUNT(dupeColumn) > 1 )

    --
    :hehe: