/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 vote220 views1 answer
Codigo crear tablas sql server
SQL
0 vote208 views1 answer
Sql server concat null
SQL
2 votes204 views1 answer
Postgresql drop primary key constraint
SQL
0 vote193 views1 answer
Authentication in sql server
SQL
5 votes208 views1 answer
Sysdate in oracle sql
SQL
0 vote186 views1 answer
Create new table pl sql
SQL
0 vote171 views1 answer
Sql table to store status
SQL
0 vote234 views1 answer
Time in sql server
SQL
36 votes218 views3 answers
Add column in mysq
SQL
3 votes204 views2 answers
Postgres alter table owner
SQL