/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 vote144 views1 answer
Update one column from another column in same table
SQL
0 vote164 views1 answer
Sql date time query find
SQL
0 vote146 views2 answers
2nd max salary query in sql
SQL
0 vote152 views1 answer
How to get one year old query from plan cache
SQL
0 vote149 views1 answer
Mariadb alter table add column if not exists example
SQL
1 vote134 views1 answer
Mysql show current queries
SQL
0 vote134 views1 answer
Check index sql server
SQL
6 votes151 views3 answers
Sql select last id
SQL
4 votes135 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote140 views1 answer
How to set sql_mode for a query in CI model
SQL