Posts mySQL - Find duplicates with having
Post
Cancel

mySQL - Find duplicates with having

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

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags