Pages

Thursday, November 19, 2009

SQL SERVER -- Duplicate Records in DB

This query will get the duplicate records from the database table

SELECT YourColumn, COUNT(YourColumn) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(YourColumn) > 1

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)