Aggregate Functions MySQL

  1. Home
  2. MySQL
  3. Aggregate Functions
  4. Queries counting duplicate records have the following form
SELECT COUNT(*), column_list
FROM tbl_name
GROUP BY column_list
HAVING COUNT(*) > 1;