Here’s how I checked for duplicate names on one table:
SELECT columnname,
COUNT(columnname) AS NumOccurrences
FROM tablename
GROUP BY columnname
HAVING ( COUNT(columnname) > 1 )
Delete Duplicate Records using SQL
Here’s an helpful links to delete duplicate records.
No comments:
Post a Comment