top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How can we count and identify duplicate records in a table?

0 votes
418 views
How can we count and identify duplicate records in a table?
posted Sep 5, 2014 by Amit Kumar Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Try this code

SELECT count(*) AS duplicate_count
FROM (
 SELECT name FROM tbl
 GROUP BY name HAVING COUNT(name) > 1
) AS t
answer Sep 6, 2014 by Vrije Mani Upadhyay
...