I have a varchar field in table Table1 called pid that is set to primary key. There is supposed to not be any duplicates here.
what syntax do I use to:
1.) find and list any duplicates
2.) is there a field type (int etc.) that will throw an error if you try to insert a duplicate #?