Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Query to show duplicate values RE: Query to show duplicate values

  • October 24, 2016 at 12:29 pm

    #1908444

    To list just the dups:

    SELECT names /*, COUNT(*) AS dup_count*/

    FROM employee

    GROUP BY names

    HAVING COUNT(*) > 1

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.