/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 vote357 views1 answer
How to find the most occuring in SQL
SQL
0 vote196 views1 answer
Uuid sqlalcomany
SQL
0 vote314 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote232 views1 answer
Sql file in postgres with pgadmin
SQL
2 votes222 views1 answer
Sql find not in list
SQL
0 vote251 views1 answer
Selecting from a view SQL
SQL
0 vote261 views1 answer
Mysql workbench not showing schemas
SQL
1 vote201 views1 answer
Multiple count in sql
SQL
3 votes232 views1 answer
Oracle cannot access v$session
SQL
0 vote207 views1 answer
Convert .mdf to .bak
SQL