/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

16 votes384 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote361 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
3 votes333 views1 answer
Get all elements sql
SQL
0 vote376 views1 answer
Uncheck constraints and delete from table
SQL
0 vote398 views1 answer
Mysql last friday of current month
SQL
0 vote350 views2 answers
Return the number of records in a single table mysql
SQL
0 vote375 views1 answer
Transaction database with php
SQL
0 vote350 views1 answer
Connect postgresql using a connection string
SQL
-2 votes359 views1 answer
Group functions in sql
SQL
1 vote359 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL