Count how many duplicates you have in a table - MySQL Snipplr Social Repository

Revision: 66059

at March 6, 2014 20:41 by marrouchi

Initial Code

SELECT COUNT(alias.id) FROM (SELECT id, COUNT(id) AS cnt
FROM table
GROUP BY id
HAVING (cnt > 1)) as alias

Initial URL

Initial Description

Count how many duplicates you have in a table

Initial Title

Count how many duplicates you have in a table

Initial Tags

Initial Language

MySQL