/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 vote242 views1 answer
Bitmap join index
SQL
0 vote208 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote241 views2 answers
Oracle create synonym
SQL
6 votes217 views5 answers
Alter table oracle
SQL
0 vote271 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote210 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote222 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote229 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote239 views1 answer
Ms sql print more than 1 variable
SQL
0 vote217 views1 answer
Install sql server windows 10
SQL