Tuesday, August 9, 2011

Find Duplicate Records

SELECT     tablefield, COUNT(tablefield) AS dup_count
FROM         table
GROUP BY tablefield
HAVING     (COUNT(tablefield) > 1)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)