Finding duplicate values in MySQL

by

Do a SELECT with a GROUP BY clause. Let’s say name is the column you want to find duplicates in:

SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;

This will return a result with the name value in the first column, and a count of how many times that value appears in the second.

More Related Contents:

  1. When I want to install MySQL I faced this issue “root account password” I forgot it
  2. difference between primary key and unique key
  3. Illegal mix of collations MySQL Error
  4. How can I initialize a MySQL database with schema in a Docker container?
  5. SQL order string as number
  6. MySQL: Fastest way to count number of rows
  7. Node.js can’t authenticate to MySQL 8.0
  8. update multiple rows using limit in mysql?
  9. Mysql 1050 Error “Table already exists” when in fact, it does not
  10. Which rows are returned when using LIMIT with OFFSET in MySQL?
  11. Speeding up row counting in MySQL
  12. How to transform a MSSQL CTE query to MySQL?
  13. How to get the latest record in each group using GROUP BY? [duplicate]
  14. MySQL ENUM type vs join tables
  15. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  16. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  17. SQL unique varchar case sensitivity question
  18. In MySQL, can I defer referential integrity checks until commit
  19. Commit data in a mysql container
  20. How do I count columns of a table
  21. Mysqldump launched by cron and password security
  22. MySQL Trigger cannot update table – getting ERROR 1442
  23. How to insert Hindi language in Mysql
  24. Converting epoch number to human readable date in mysql
  25. MySQL delete duplicate records but keep latest
  26. MySQL 5.6 – DENSE_RANK like functionality without Order By
  27. Automatic Rollback if COMMIT TRANSACTION is not reached
  28. MySQL cartesian product between two SELECT statements
  29. Sum until certain point – MySql
  30. Speeding up mysql dumps and imports [closed]

Leave a Comment