Change style:

Big /
Small

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/

Expand | Embed | Plain Text

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

Report this snippet Tweet

Comment:

You need to login to post a comment.