/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 vote138 views1 answer
How to get initials in sql
SQL
3 votes177 views2 answers
How to open postgresql in windows
SQL
2 votes166 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote177 views1 answer
Sql select sum group by id laravel join
SQL
13 votes157 views4 answers
What is sql
SQL
-1 vote199 views1 answer
Add 10 to all numbers in a column sql
SQL
-1 vote137 views1 answer
Add column alter table default value
SQL
7 votes157 views1 answer
Mysql remote connection command line
SQL
8 votes147 views5 answers
Alter table add column with default value
SQL
3 votes169 views2 answers
Sql not contains
SQL