title: Selecting from table where a name appears twice
body: <p>I want to select from a table where a name appears twice.</p>
  
  <p>For example I have a table like this,</p>
  
  <pre><code>ID          Name
  ----       ------
  1          Jane John
  2          Kevin Smith
  3          Jane John
  </code></pre>
  
  <p>What I want is for the output to show where Jane John appear twice so it should look something like this:</p>
  
  <pre><code>ID          Name
  ----       ------
  1          Jane John
  3          Jane John
  </code></pre>
  
  <p>I tried looking around on stackoverflow but couldn't find an exact and easy answer. </p>
  
  <p>I'm using oracle SQL Developer. </p>