/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 vote223 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote170 views1 answer
IIF
SQL
0 vote179 views1 answer
Sql case sttement with set
SQL
0 vote182 views1 answer
Sql server change schema of a table
SQL
1 vote172 views1 answer
Change old domain to new domain name wordpress
SQL
2 votes165 views1 answer
Oracle sql drop column if exists
SQL
0 vote143 views1 answer
Mysql workbench search all tables
SQL
8 votes221 views2 answers
Sqlsrv default port
SQL
0 vote180 views1 answer
Oracle current session details
SQL
0 vote171 views2 answers
Sqlite unique
SQL