Showing posts with label Find Duplicate Rows. Show all posts
Showing posts with label Find Duplicate Rows. Show all posts

Saturday, May 14, 2011

Sql-Server, find Duplicate Rows with Count

select Count(ID), Name, Email,Comment
FROM TableName     
group by Name, Email,Comment
having Count(ID)>1