netnerds.net

15May/083

T-SQL: Find Duplicates Without Using JOIN

I'd forgotten about this lil trick.

select eUserName from eAttribute GROUP BY eUserName  HAVING COUNT( eUserName) > 1
Posted by: Chrissy   Filed under: SQL Server Leave a comment
Comments (3) Trackbacks (0)
  1. LaptopHeaven
    May 15th, 2008 - 19:01

    why not use SELECT DISTINCT?

    ( REPLY )
  2. Chrissy
    June 9th, 2008 - 15:56

    Because that does not solve the problem — I want to find duplicate records, not distinct records.

    ( REPLY )

Leave a comment


No trackbacks yet.

« MS Defender Error: "Mallware Signeture Download" Appears Legitimate (Unfortunately). SQL Server: Change the Owner of All Tables to "dbo" »

About

    We are IT consultants who grew up living and loving life in Cajun Country.

Authors

Categories