mySQL - Find duplicates with having

[Costas]

-https://stackoverflow.com/a/5120086

SELECT    count(*), email
FROM      user_changes
GROUP BY  email
HAVING    count(*) > 1

---

--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
)