title: Find duplicates, display each result in sql
body: <p>I want to write something like this :</p>
  
  <pre><code>select t.id, t.name, from table t
  group by t.name having count(t.name) &gt; 1
  </code></pre>
  
  <p>To produce the following :</p>
  
  <pre><code>id      name  count 
  904834  jim    2
  904835  jim    2
  90145   Fred   3
  90132   Fred   3
  90133   Fred   3
  </code></pre>