Wednesday, August 18, 2010

How to find duplicate records in SQL Server?

SELECT UserID FROM employee
GROUP BY userid
HAVING count(*) > 1

No comments:

 
Feedback Form