title: How to distinguish rows in a database table on the basis of two or more columns while returning all columns in sql server
body: <p>I want to distinguish Rows on the basis of two or more columns value of the same table at the same time returns all columns from the table.
  Ex: I have this table
    <a href="https://i.stack.imgur.com/TVevn.png" rel="nofollow noreferrer">DB Table</a></p>
  
  <p>I want my result to be displayed as: filter on the basis of type and Number only. As in abover table type and Number for first and second Row is same so it should be suppressed in result.</p>
  
  <pre><code>txn item Discrip Category type   Number            Mode
  60  2    Loyalty    L     6174  XXXXXXX1390         0
  60  4    Visa       C     1600  XXXXXXXXXXXX4108    1
  </code></pre>
  
  <p>I have tried with sub query but yet unsuccessful. Please suggest what to try.
  Thanks </p>