title: SQL query for non duplicate records
body: <p>I'm attempting to build a query that will return all non duplicate (unique) records in a table.  The query will need to use multiple fields to determine if the records are duplicate.  </p>
  
  <p>For example, if a table has the following fields; PKID, ClientID, Name, AcctNo, OrderDate, Charge, I'd like to use the AcctNo, OrderDate and Charge fields to find unique records.</p>
  
  <p>Table</p>
  
  <pre><code>PKID-----ClientID-----Name-----AcctNo-----OrderDate-----Charge
  1        JX100        John     12345      9/9/2010      $100.00
  2        JX220        Mark     55567      9/9/2010       $23.00
  3        JX690        Matt     89899      9/9/2010      $218.00
  4        JX100        John     12345      9/9/2010      $100.00
  </code></pre>
  
  <p>The result of the query would need to be:</p>
  
  <pre><code>PKID-----ClientID-----Name-----AcctNo-----OrderDate-----Charge
  2        JX220        Mark     55567      9/9/2010       $23.00
  3        JX690        Matt     89899      9/9/2010      $218.00
  </code></pre>
  
  <p>I've tried using SELECT DISTINCT, but that doesn't work because it keeps one of the duplicate records in the result.  I've also tried using  HAVING COUNT = 1, but that returns all records.</p>
  
  <p>Thanks for the help.</p>