Posted By

Seich on 12/07/10


Tagged

sql numbers count duplicates


Versions (?)

Finding duplicate records and number of duplicate records


 / Published in: SQL
 

URL: http://www.iishacks.com/2008/01/18/find-duplicate-records-and-the-number-of-duplicates-in-sql-mysql/

  1. SELECT COLUMN, count(COLUMN) AS cnt FROM TABLE GROUP BY COLUMN ORDER BY cnt DESC

Report this snippet  

You need to login to post a comment.