/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

1 vote105 views1 answer
Sql server datetime vs datetime2
SQL
0 vote108 views1 answer
Dapper run sql script with parameters
SQL
1 vote112 views2 answers
Oracle list partitioned tables
SQL
2 votes91 views1 answer
Codeigniter print last sql query
SQL
0 vote104 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote140 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
49 votes166 views6 answers
Alter table add column
SQL
1 vote90 views1 answer
Sql auto timestamp
SQL
0 vote133 views1 answer
How to get table current identity value in sql server
SQL
8 votes101 views2 answers
Replace string value in sql
SQL