title: T-SQL: "Compress" rows with equal values to one
body: <p>Is there a chance to show only one row if there are any rows with same values?</p>
  
  <p>I've the following scenario:</p>
  
  <blockquote>
    <p>ID | Column A | Column B | Column C</p>
    
    <p>1  |  2      |    'test' |     5</p>
    
    <p>2  |  3      |     'test'|     6</p>
    
    <p>3  |  2      |     'test'|      5</p>
  </blockquote>
  
  <p>In this scenario I want only show the following resultset:</p>
  
  <blockquote>
    <p>ID | Column A | Column B | Column C</p>
    
    <p>1  |  2      |    'test' |     5</p>
    
    <p>2  |  3      |     'test'|     6</p>
  </blockquote>
  
  <p>Thanks for your help.</p>
  
  <p>Regards, pro</p>