title: how to find duplicate records in SQL without any primary key?
body: <p>Is there any way to find non distinct records in a table?
  I have a table which could have exact same records. Table contain more than 10 million records. </p>
  
  <pre><code>ID Name
  1  hello
  1  hello
  2  world
  2  world
  3  yikes
  </code></pre>
  
  <p>I want to select single copy of all those records which are appearing more than once. I want this result from above table.</p>
  
  <pre><code>ID Name
  1  hello
  2  world
  </code></pre>