/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 vote358 views1 answer
How to insert a uniqueidentifier in sql
SQL
9 votes392 views3 answers
Import DB through mysql console
SQL
2 votes403 views2 answers
Null column to 0 in mysql
SQL
7 votes364 views1 answer
Sql server management studio turn on line numbers
SQL
6 votes348 views2 answers
If not exists insert sql
SQL
0 vote359 views2 answers
Postgres having
SQL
0 vote382 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote465 views1 answer
Reset a table's identity column and remove test records
SQL
2 votes398 views1 answer
Mysql shell insert into
SQL
1 vote320 views1 answer
Mysqli connect
SQL