title: SQL Server Duplicate Checking
body: <p>What is the best way to determine duplicate records in a SQL Server table?</p>
  
  <p>For instance, I want to find the last duplicate email received in a table (table has primary key, receiveddate and email fields).</p>
  
  <p>Sample data:</p>
  
  <pre><code>1  01/01/2008 stuff@stuff.com
  2  02/01/2008 stuff@stuff.com
  3  01/12/2008 noone@stuff.com
  </code></pre>