title: SQL Select That Appear More than Once with Different ID
body: <p>I have a large table with a large amount of columns but for this I will only be interested in 3 columns, so my date is as below.</p>
  
  <pre><code>PartNumber  BrandID PartTerminonogyID
  1234AD      343
  DD93873 DAB 343
  1-8383-343  STE 4424
  444 OTE 5656
  444 NYT 4543
  3434    IDY 4543
  64545   IDH 3455
  64545   IDH 8585
  </code></pre>
  
  <p>What I want is to find each PartNumber/BrandID combo that has more than one PartTerminologyID</p>
  
  <p>Keep in mind that I cannot sure part number alone as different manufacturers may have the same part number for completely different items.  So the identifier is PartNumber/BrandID combo, you can think of this as a SKU if that helps.  And what I want is to see all cases where the same SKU has more than one PartTerminologyID.  I would like to see each PartTerminologyID with the results as well.</p>