/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

25 votes217 views6 answers
Change column name mysql
SQL
8 votes139 views1 answer
Mysql restore database
SQL
0 vote123 views1 answer
Exec procedure oracle
SQL
1 vote121 views1 answer
Oracle start job
SQL
0 vote125 views4 answers
Mysql replace regex
SQL
0 vote123 views1 answer
Sql case sttement with set
SQL
39 votes229 views5 answers
Sql drop column
SQL
1 vote133 views1 answer
Mysql f# examples
SQL
42 votes209 views6 answers
Rename table sql server
SQL
1 vote130 views1 answer
Oracle grant on all tables in schema
SQL