title: Need to select ALL columns while using COUNT/Group By
body: <p>Ok so I have a table in which ONE of the columns have a FEW REPEATING records.</p>
  
  <p>My task is to select the REPEATING records with all attributes.</p>
  
  <p>CustID FN LN DOB City State</p>
  
  <p>the DOB has some repeating values which I need to select from the whole table and list all columns of all records that are same within the DOB field..</p>
  
  <p>My try...</p>
  
  <pre><code>Select  DOB, COUNT(DOB) As 'SameDOB' from Table1
  
  group by DOB
  
  HAVING (COUNT(DOB) &gt; 1)
  </code></pre>
  
  <p>This only returns two columns and one row 1st column is the DOB column that occurs more than once and the 2nd column gives count on how many.</p>
  
  <p>I need to figure out a way to list all attributes not just these two...</p>
  
  <p>Please guide me in the right direction.</p>