Information
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
Older Posts
Home
Subscribe to:
Posts (Atom)