/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

0 vote362 views1 answer
SQL Cut part string
SQL
10 votes344 views2 answers
Mysql alter add foreign key
SQL
0 vote328 views1 answer
Max mysql
SQL
0 vote317 views1 answer
Run postgresql dump to csv
SQL
0 vote335 views1 answer
How to Remove milliseconds from Date time
SQL
25 votes323 views5 answers
Uninstall mysql ubuntu
SQL
5 votes342 views2 answers
To date oracle
SQL
0 vote334 views1 answer
Where name ends in SQL
SQL
4 votes343 views1 answer
Find tables with column name in sql
SQL
1 vote331 views1 answer
Backup mysql data only
SQL