/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

5 votes195 views1 answer
How to check nls format in oracle
SQL
1 vote206 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote199 views1 answer
Ansi sql count duplicate rows
SQL
2 votes198 views2 answers
Set database timezone mysql
SQL
0 vote201 views1 answer
Linebreak sql
SQL
1 vote186 views1 answer
Mysql get character set
SQL
14 votes196 views2 answers
Oracle add column with default value
SQL
1 vote206 views1 answer
Sql into vs insert into
SQL
0 vote200 views1 answer
T-sql check if data exists
SQL
0 vote229 views1 answer
Sql quary stuf
SQL