select Count(ID), Name, Email,Comment
FROM TableName
group by Name, Email,Comment
having Count(ID)>1
FROM TableName
group by Name, Email,Comment
having Count(ID)>1
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
Subscribe to:
Posts (Atom)