Posted By

marrouchi on 03/06/14

Tagged

Viewed 717 times

Favorited by 0 user(s)

/ Published in: MySQL

Count how many duplicates you have in a table

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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

Comment:

You need to login to post a comment.