title: Checking Duplicate Records in Table Where Id is Identity
body: <p>In my table, ID is primary key field and identity column.
  I want to check duplicate records.
  (Certainly duplicate records do not have same ID)</p>
  
  <p>And do not have date fields same.</p>
  
  <p>How do I check this.</p>
  
  <p>Extra Detail: I have 10 columns with 1 ID, 2 Date, and other 3 string, 3 Int, 1 bit.</p>
  
  <p>Thansk in Advance.</p>