Clueless UsersHere’s a real simple query to detect duplicate records (based on a single field). This query works in both MySQL and Microsoft SQL.
SELECT FieldName, COUNT( FieldName ) AS Occurrences
FROM TableName
GROUP BY FieldName
HAVING ( COUNT( FieldName ) > 1 )