/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 vote159 views1 answer
Show function mysql
SQL
8 votes200 views1 answer
Mac restore mysql database command line
SQL
2 votes169 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote182 views1 answer
Multiple like values for single column postgres
SQL
0 vote195 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote153 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote168 views1 answer
Alter check command
SQL
1 vote174 views1 answer
Nullif postgresql
SQL
4 votes151 views2 answers
Select first and last row mysql
SQL
8 votes149 views5 answers
Grant permission in postgres
SQL