title: Get the distinct of two columns that are the reverse of each other in SSMS
body: <p>Apologies if this is a duplicate question, I can't seem to find it anywhere else.</p>
  
  <p>I have a table like so:</p>
  
  <pre><code>column1 column2 column3
  entry 1 A   B
  ENTRY 2 A   C
  ENTRY 3 B   C
  ENTRY 1 B   A
  ENTRY 2 C   A
  ENTRY 3 C   B
  </code></pre>
  
  <p>The table I'm using has more columns but the idea is the same.</p>
  
  <p>Is there an easy clean way to get the distinct entries (i.e. I'm  only interested in bringing back Entry 1 once, not twice.</p>