Finding Duplicates with T-SQL


SELECT UserID, COUNT(UserID) AS Total
FROM tblUsers
GROUP BY UserID
HAVING COUNT(UserID) > 1