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
Posted by at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)