Home Forums SQL Server 2008 T-SQL (SS2K8) filter duplicate students via T-SQL RE: filter duplicate students via T-SQL

  • April 19, 2013 at 7:49 pm

    #1608440

    SELECT EmpPin, trxdate, trxtime, COUNT(*) AS dupes

    FROM dbo.rawtrx

    GROUP BY EmpPin, trxdate, trxtime

    HAVING (COUNT(*) > 1)

    play around with this query