title: How do I find duplicates across multiple columns?
body: <p>So I want to do something like this sql code below:</p>
  
  <pre><code>select s.id, s.name,s.city 
  from stuff s
  group by s.name having count(where city and name are identical) &gt; 1
  </code></pre>
  
  <p>To produce the following, (but ignore where only name or only city match, it has to be on  both columns):</p>
  
  <pre><code>id      name  city   
  904834  jim   London  
  904835  jim   London  
  90145   Fred  Paris   
  90132   Fred  Paris
  90133   Fred  Paris
  </code></pre>