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:
Subscribe to: Posts (Atom)