select duplicate_column from table_with_duplicates whereHope that helps someone.
select count(a.duplicate_column) from table_with_duplicates a
where a.duplicate_column = table_with_duplicates.duplicate_column
) > 1
group by duplicate_column
Monday, July 20, 2009
Ever wondered how to select only rows that have some duplicate from a field? Well, here is one way that worked pretty well:
Posted by Vernon Singleton at Monday, July 20, 2009