title: MsAccess - How to find duplicate records only
body: <p>I have table -</p>
  
  <pre><code>Tbl1
  
  ID       Sort   Amount Price  Address
  000123   AAA    135.00 25.00  25Grant
  000123   AAB    135.00 15.00  27Pent
  000124   AAC    118.00 16.00  47Bay
  000125   BBB    116.00 17.00  56Third
  000125   BBB    116.00 66.50  56Third
  </code></pre>
  
  <p>I need to select only duplicate records for fields ID, Sort, Amount.
  I don't need to select Price and Address fields.</p>
  
  <p>I am expecting result:</p>
  
  <pre><code>ID      Sort  Amount
  000125  BBB   116.00 
  000125  BBB   116.00
  </code></pre>
  
  <p>I know I can use "Duplicate Records query" in MsAccess query wizard.
  But I need to understand how do I do it in SQL.</p>
  
  <p>When I viewed "Design" or "SQL" view I still not completely
  understand the algorithm.</p>
  
  <p>If someone could write -finding duplicates query- here with the explanation,
  I'd be appreciate...</p>