title: find duplicate record in mysql without original
body: <p>I want to pull out duplicate records in a MySQL Database. This can be done with:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT firstname, 
     lastname, 
     list.address 
  FROM list
     INNER JOIN (SELECT address
                 FROM   list
                 GROUP  BY address
                 HAVING COUNT(id) &gt; 1) dup
             ON list.address = dup.address;
  </code></pre>
  
  <p>Which results in:</p>
  
  <pre><code>JIM    JONES    100 MAIN ST
  JOHN   SMITH    100 MAIN ST
  </code></pre>
  
  <p>I would like to pull it so that it shows each row that is a duplicate. Something like:</p>
  
  <pre><code>JIM    JONES    100 MAIN ST
  </code></pre>
  
  <p>if the result is :</p>
  
  <pre><code>JIM    JONES    100 MAIN ST
  JOHN   SMITH    100 MAIN ST
  JOHN   SMITH    100 MAIN ST
  </code></pre>
  
  <p>I would like to pull it so that it shows each row that is a duplicate. Something like:</p>
  
  <pre><code>JOHN   SMITH    100 MAIN ST
  JOHN   SMITH    100 MAIN ST
  </code></pre>
  
  <p>I want only duplicate data not original data</p>