/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 vote324 views1 answer
Adding a default constraint to an existing column in sql
SQL
1 vote332 views1 answer
Oracle character set
SQL
3 votes329 views1 answer
Mysql replace string in table
SQL
0 vote375 views1 answer
SQL FROM-Klausel
SQL
3 votes332 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
1 vote375 views1 answer
Sql server if exists update else insert
SQL
0 vote377 views1 answer
Check if mysql db is used
SQL
0 vote360 views1 answer
Sql sum if
SQL
0 vote376 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote328 views1 answer
Get last updated row sql server
SQL