title: How To Select all the Duplicate Records in a single table in SQl
body: <p>I want to select all the duplicate records in a single column from single table. i have used the following code .but in that i am able to get only one duplicate record. the code is like below</p>
  
  <pre><code>SELECT Datetime COUNT(*)FROM  users GROUP BY Datetime HAVING  COUNT(*) &gt; 1
  </code></pre>
  
  <p>But i want result like below table</p>
  
  <pre><code>TableName:MyTable
  DateTime
  04/16/2015
  04/16/2015
  04/16/2015
  04/16/2015
  </code></pre>
  
  <p>but my query giving like below.</p>
  
  <pre><code>DateTime
   04/16/2015 count(4)
  </code></pre>
  
  <p>Please help me in this</p>