sql - Distinct value appearing more than once -

I am trying to show unique values ​​from Table B, where it happens on more than one occasion

Can anyone help with this? Here is my code but choose from the difference B is wrong (field 1)> 1

something like

  Select the field 1, count (*) from Field 1 to Group (*) & gt; 1  

Some details depend on your database engine that you have not specified.