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