title: Sql statement needed to display duplicates to 1
body: <p>I recieved some help but it did not resolve my issue.  I am trying to create the below table from a table that contains multiple invoices numbers and invoice codes.  I want to see the invoices numbers(2 or more of the same number) for any code(multiple codes for the same invoice number is expected)  I am not totally new to SQL but I am by far no expert and look for guidance.  Please see below table           </p>
  
  <pre><code> Invoice#      Inv Code 
   22567          CN
   22567          FR
   25855          CN
   25855          FR
  </code></pre>
  
  <p>There are other invoices and other codes in the table, but I only want those codes that have 2 or more of the same invoice number attached to them. Thnx</p>