/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 vote262 views3 answers
Mysqli count down
SQL
0 vote297 views3 answers
Condition in count sql
SQL
0 vote303 views1 answer
How to move a columns location in mysql
SQL
0 vote240 views2 answers
Spring properties file for db
SQL
0 vote274 views1 answer
Multiple left join mysql
SQL
13 votes287 views6 answers
Mysql remove duplicates
SQL
0 vote316 views1 answer
Sql datum formatieren
SQL
11 votes289 views2 answers
You are using safe update mode
SQL
0 vote268 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote258 views1 answer
Mysql workbench not showing schemas
SQL