title: SELECT distinct for multiple rows of same ID
body: <p>I have a view result that looks like below</p>
  
  <pre><code>B_ID | CL_ID | TPROVIDER | STMT_ENBLD | Source_ID
  1    | ABCD  |    T1     |     Y      |    1
  2    | ABCD  |    T1     |     Y      |    2
  3    | ASDF  |    T2     |     N      |    1
  4    | QWEI  |    T1     |     Y      |    1
  5    | ZXXC  |    T1     |     Y      |    1
  6    | ZXXC  |    T1     |     Y      |    2
  </code></pre>
  
  <p>I want a query which would give result like</p>
  
  <pre><code>B_ID | CL_ID | TPROVIDER | STMT_ENBLD | Source_ID
  2    | ABCD  |    T1     |     Y      |    2
  3    | ASDF  |    T2     |     N      |    1
  4    | QWEI  |    T1     |     Y      |    1
  6    | ZXXC  |    T1     |     Y      |    2
  </code></pre>
  
  <p>when there are multiple records with same CL_ID, it should check If TPROVIDER = 'T1' and STMT_ENBLD ='Y' and if so,it should fetch only one record from that two, where Source_ID=2</p>