title: Return all duplicate rows
body: <p>I've written this code to find duplicates and it works fine:</p>
  
  <pre><code>SELECT *
  FROM StyleTable 
  GROUP BY Color
  HAVING count(*) &gt; 1 
  </code></pre>
  
  <p>The problem is, it's returning just one of the duplicate rows. Is it possible to return all the duplicate rows? I'm guessing it may have something to do with the 'GROUP BY' but I'm not sure how to change it. I don't want to delete the values, just return them.</p>