title: SQL Select duplicate values without grouping
body: <p>I've checked all the related questions but can't find exactly what I need.</p>
  
  <p>I need to return any data where one particular field is the same for each record, but I can't use <code>group by</code> because I need to see all the duplicated records, I don't just want a count of them.</p>
  
  <p>I've tried using <code>group by</code> and <code>having count(field) &gt; 1</code> and various forms of simple <code>select</code> and other ways of trying to use <code>count()</code> with no luck.</p>
  
  <p>Basically I need to see everything in the table apart from where one particular field has a unique value. If it isn't unique I need to view it.</p>
  
  <p>There are additional <code>where</code> requirements but for simplicity I'm not including them here. I'm using SSMS 2008 R2.</p>
  
  <p>Thanks</p>
  
  <p><strong>Example:</strong></p>
  
  <p>Data:</p>
  
  <pre><code>Col1  |  Col2  |  Col3
  ----------------------
  abc      wow      13/05/2016
  abc      wow      10/05/2016
  def      wow      13/05/2016
  ghi      wow      13/05/2016
  ghi      wow      10/05/2016
  jkl      wow      01/01/2016
  </code></pre>
  
  <p>Expected result:</p>
  
  <pre><code>Col1  |  Col2  |  Col3
  ----------------------
  abc      wow      13/05/2016
  abc      wow      10/05/2016
  ghi      wow      13/05/2016
  ghi      wow      10/05/2016
  </code></pre>
  
  <p>I am looking to show anything that does not have a unique value in Col1</p>