sele myfield1,myfield2 from ... group by 1,2 having cnt(*)=2

>I can easily do this with 2 statements, but what would be the SQL logic to Select only records where there were more than one meeting the criteria:
>
>

>MyField1     MyField2
>========     ========
>John         12345
>Jim          98765
>John         12345
>

>
>I only want this as a result:
>
>

>John         12345
>

>
>I only want 1 record with John and do not want Jim at all.
>
>Thanks, Renoir