It should be simple but for some reason I can't get it to work right.

I need to query a table and return the primary key if there are more than one record with the same value in another column. For example, I want the primary key of all Vendor records in which we have more than one in vendor in each state.