/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

8 votes368 views1 answer
Today minus 15 days postgresql
SQL
0 vote342 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote356 views1 answer
TSQL convert csv to table
SQL
0 vote358 views2 answers
Collation in sql
SQL
1 vote352 views1 answer
Postgres convert exisiting column to text
SQL
0 vote353 views1 answer
Sql count total by foreign key
SQL
1 vote359 views1 answer
Sql select all from one table and one column from another
SQL
0 vote346 views2 answers
Sql join on wildcard
SQL
0 vote344 views1 answer
Oracle character index
SQL
0 vote341 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL