/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 vote236 views1 answer
Get null value in sql
SQL
0 vote199 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote267 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
5 votes214 views1 answer
Sql integer to serial
SQL
0 vote229 views1 answer
Microsoft word insert sql code
SQL
0 vote255 views2 answers
Soql last year
SQL
0 vote193 views1 answer
RowDataPacket
SQL
1 vote209 views1 answer
Psql filed name alter
SQL
0 vote276 views1 answer
Liquibase update row
SQL
0 vote193 views1 answer
Sql composite key
SQL