/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

6 votes250 views2 answers
Database url postgres
SQL
0 vote148 views1 answer
Mysql set column equal to another automatic
SQL
37 votes357 views3 answers
Sql check duplicate value in column
SQL
-1 vote164 views1 answer
Count occurrences sql
SQL
0 vote155 views1 answer
Sauvegarde complète my sql
SQL
1 vote167 views1 answer
Mysql order by desc null last
SQL
2 votes147 views1 answer
Oracle number to percentage
SQL
0 vote156 views2 answers
Mysql get routine parameter list
SQL
5 votes159 views3 answers
Mysql remove unique constraint
SQL
0 vote168 views1 answer
Postgresql log
SQL