/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 vote173 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote187 views1 answer
Primary key multiple colums
SQL
7 votes190 views2 answers
Mysql default value
SQL
15 votes173 views2 answers
Open postgress in terminal mac
SQL
4 votes206 views1 answer
Postgres delete last row
SQL
0 vote189 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote171 views4 answers
How to drop all tables in sql
SQL
3 votes165 views3 answers
Stop mysql service ubuntu
SQL
27 votes190 views6 answers
Sql update record
SQL
0 vote194 views1 answer
Mysql best varchar length size
SQL