/SQL/Find duplicate users by email address in mysql

Find duplicate users by email address in mysql

SELECT users.name, users.uid, users.mail, from_unixtime(created)
FROM users
INNER JOIN (
  SELECT mail
  FROM users
  GROUP BY mail
  HAVING count(mail) > 1
) dupes ON users.mail = dupes.mail
ORDER BY users.mail;

Source: lutios.com

Similar codes

4 votes247 views3 answers
Postgres drop all tables
SQL
0 vote184 views1 answer
Min:sec datediff mssql
SQL
2 votes231 views1 answer
Orcale index size
SQL
0 vote177 views1 answer
Lost connection to mysql
SQL
0 vote236 views1 answer
How to pass list as parameter in SQL query
SQL
12 votes243 views10 answers
Google
SQL
1 vote200 views1 answer
Sql select max value from multiple rows
SQL
0 vote176 views1 answer
Database springboot
SQL
0 vote221 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote197 views4 answers
Mysql replace regex
SQL