/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 vote161 views1 answer
Mysql equivalent decode oracle
SQL
0 vote159 views1 answer
Oracle winter time change
SQL
3 votes223 views1 answer
Ssh check mysql version
SQL
0 vote136 views1 answer
Column ' ' in field list is ambiguous
SQL
2 votes138 views2 answers
Spring where to put the data sql
SQL
12 votes129 views4 answers
Mysql ifnull
SQL
5 votes134 views1 answer
Add column table sql default value
SQL
2 votes131 views1 answer
Plsql left() function
SQL
0 vote138 views1 answer
Guid string to binary better
SQL
0 vote90 views1 answer
Bigquery information_schema schema all columns
SQL