title: MySQL Show Duplicates
body: <p>I am currently using a version of:</p>
  
  <pre><code>SELECT a,b
  FROM tbl
  GROUP BY a,b
  HAVING COUNT(*)&gt;1;
  </code></pre>
  
  <p>I know the results are correct given what actions I've taken on the table. But, it doesn't actually show me the duplicates. The "GROUP BY" clause blocks the other half of the records from showing.</p>
  
  <p>I know this probably has a simple solution, but how do I actually <em>show</em> the duplicates? In other words, if there are 110 duplicates, I should get 220 records.</p>
  
  <p>Thanks</p>