NeonRant
11/18/2019 - 2:10 AM

Find deplicate rows

This query returns a list of rows that have more than one duplicate value. Yo can check one column or more than one for uniqueness.

duplicates.sql
content_copyfile_download
SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1