Advanced Search

MySQL Select duplicates

/ Published in: MySQL
Save to your folder(s)
Instead of the standard return of duplicates, this will actually show the rows that are duplicated, making it easier to see the data

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT * 
  2. FROM [tablename]
  3. INNER JOIN (
  4. SELECT COUNT( * ) , [columnOfDuplicates]
  5. FROM [tablename]
  6. GROUP BY [columnOfDuplicates]
  7. HAVING COUNT( * ) >1
  8. ) AS t2 ON [tablename].[columnOfDuplicates] = t2.[columnOfDuplicates]

Report this snippet


Comments

You need to login to view comments.