/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 vote268 views1 answer
Sql query to force the database to be drop
SQL
2 votes260 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
5 votes246 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote264 views2 answers
Psql commande \gset
SQL
3 votes258 views2 answers
How to start postgresql on windows
SQL
15 votes263 views1 answer
Mysql int range
SQL
0 vote254 views2 answers
Create fulltext index mysql
SQL
2 votes284 views1 answer
How to select from mssql
SQL
0 vote240 views1 answer
Trim sql oracle
SQL
0 vote256 views1 answer
Arithmetic expression in sql
SQL