/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

4 votes303 views4 answers
Rollback in sql
SQL
0 vote297 views1 answer
Ms sql database data size
SQL
4 votes286 views3 answers
Create database in mySQL
SQL
14 votes290 views3 answers
SQL trim
SQL
6 votes275 views1 answer
Rank function in oracle with example
SQL
0 vote294 views1 answer
Sql datediff db2
SQL
0 vote241 views1 answer
Finish transaction sql
SQL
1 vote291 views1 answer
How to group by month using sql server
SQL
1 vote297 views1 answer
Mysql select if empty result
SQL
0 vote308 views1 answer
View to table sql
SQL