Mega Code Archive

 

Categories / MySQL / Aggregate Functions

 

Queries counting duplicate records have the following form

SELECT COUNT(*), column_list FROM tbl_name GROUP BY column_list HAVING COUNT(*) > 1;