/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 votes253 views1 answer
Mysql select greater than yesterday
SQL
3 votes276 views2 answers
How to start postgresql on windows
SQL
0 vote326 views1 answer
Sql datum formatieren
SQL
0 vote275 views1 answer
Mod in sql
SQL
0 vote272 views1 answer
Postgres where
SQL
-1 vote262 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
1 vote299 views5 answers
What is in operator in sql
SQL
0 vote278 views1 answer
Python mysql query to dataframe
SQL
1 vote271 views2 answers
Mysql type conversion
SQL
1 vote270 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL