title: Finding duplicate email addresses
body: <p>I need to find duplicate emails in our database.  I am looking on one table for this information.  What I have so far</p>
  
  <pre><code> SELECT name.email, name.ID
  
   From Name
   Group BY Name.ID, Name.EMAIL
   Having Count(*) &gt; 1
  </code></pre>
  
  <p>I know that its wrong, but not sure how to write it appropriately.</p>