title: Access SQL: How to find duplicate records between dates
body: <pre><code>    SN            DATE
  ===========    =========
      111         1/1/2014
      222         2/1/2014
      333         3/1/2014
      111         4/1/2014
      222         5/1/2014
      333         6/1/2015
      222         7/1/2015
      111         8/1/2015
      333         9/1/2015
      111         10/1/2015
      111         11/1/2015
  </code></pre>
  
  <p>I have a table with 2 columns (<code>SN</code> and <code>DATE</code>). I would like to create a query that will find duplicate <code>SN</code> between <code>1/1/2014</code> and <code>31/12/2014</code>. I want to count duplicates and show each row that is a duplicate with <code>SN</code> and <code>DATE</code>. </p>