Find duplicates in the same table in MySQL

by

You can use a grouping across the columns of interest to work out if there are duplicates.

SELECT
    artist, release_id, count(*) no_of_records
FROM table
GROUP BY artist, release_id
HAVING count(*) > 1;

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  3. MySQL string replace
  4. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  5. MySQL – Trigger for updating same table after insert
  6. How do I get the current time zone of MySQL?
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. MySQL select one column DISTINCT, with corresponding other columns
  9. How to get the difference in years from two different dates?
  10. Mysql Convert Column to row (Pivot table )
  11. MySQL grant all privileges to database except one table
  12. Writing optional parameters within stored procedures in MySQL? [duplicate]
  13. How to get all columns’ names for all the tables in MySQL?
  14. How do I get MySQL to use an INDEX for view query?
  15. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  16. Restore the mysql database from .frm files
  17. Mysql insert random datetime in a given datetime range
  18. Greatest value of multiple columns with column name?
  19. insert data from one table to another in mysql
  20. MySQL UPDATE syntax with multiple tables using WHERE clause
  21. How does MySQL Auto Increment work?
  22. MySQL load data infile – acceleration?
  23. mysql – Dynamic column alias
  24. How to close sqlalchemy connection in MySQL
  25. How do I lock on an InnoDB row that doesn’t exist yet?
  26. MySQL Fulltext Search Score Explained
  27. Multi-Column Primary Key in MySQL 5
  28. Should I always prefer MySQL InnoDB over MyISAM?
  29. MySQL add 12 hours to a time field
  30. mySQL regex in the where clause

Leave a Comment