How to find duplicates with a query in MySQL database
<p>I need to find inside my table on my MySQL database duplicated values with the same name but with different sport.
Here is an example of data:</p>

<pre><code>John Smith    Athletics
Edward Green  Athletics
Edward Green  Fencing
Jim Brown     Rugby
Jim Brown     Rowing
Jim Brown     Sailing
Stan Smith    Football
Stan Smith    Football
</code></pre>

<p>Well, I'd like to make a query which give me this result:</p>

<pre><code>Edward Green  Athletics
Edward Green  Fencing
Jim Brown     Rugby
Jim Brown     Rowing
Jim Brown     Sailing
</code></pre>

<p>As I said, only that values with the same name but different sport, in order to find namesakes.</p>