Showing posts with label Query to fetch duplicate Rows. Show all posts
Showing posts with label Query to fetch 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