1
2
3
4
5
6
-https://stackoverflow.com/a/5120086
SELECT count(*), email
FROM user_changes
GROUP BY email
HAVING count(*) > 1
1
2
3
4
5
6
7
8
--https://stackoverflow.com/a/688551
SELECT talamasca.id c FROM talamasca GROUP BY talamasca.id HAVING c > 1
--then find duplicates and select the full rows
select * from talamasca where id in (
SELECT talamasca.id c FROM talamasca GROUP BY talamasca.id HAVING c > 1
)
origin - https://www.pipiscrew.com/?p=16532 mysql-find-duplicates-with-having