I have a field called PartNumber. I know there a duplicates in it and I am wanting to create SQL query that returns those duplicates. I was looking around and it seems that everyone just wants to know what the duplicates are and not actually list the duplicate rows with a RecordID or Unique ID. Can someone help me?