I have a table with several columns, including one ID field containing a unique key. What I want to do is select all duplicate records from the table based on one of the columns, say the Item number field. Is there a simple way to do that? I know using unique can give me the non-dupe records, but I don't know how to get only the duplicates.
Thanks!
PETERV
Syracuse, NY &
Boston, MA
Thanks!
PETERV
Syracuse, NY &
Boston, MA