title: SQL: Find records with matching values on a set of columns
body: <p>I'm using SQL Server 2008 RD.</p>
  
  <p>I've got the following table say <code>myTable</code> consisting of a number of columns. <code>AccID</code> and <code>AccName</code> are the columns in which I'm interested in and non of them is a primary-key. So I want to obtain all the records having at least a duplicate (there could be more than 2 rows agreeing on <code>AccID</code> and <code>AccName</code>).</p>
  
  <pre><code>  AccID     AccName
  1 333       SomeName1
  2 333       SomeName1
  3 444       SomeName2
  4 444       SomeName2
  5 444       SomeName2
  </code></pre>
  
  <p>How can I do this with SQL?</p>