'Filter rows from group by clause postgresql

I have below table, Now I want group by on col_1, and want to select data of that group which has col_2='ValueNet' and col_3='no' and also want to exclude row which satisfy before said condition. (i.e col_2='ValueNet' and col_3='no')

col_1  | col_2     |   col_3 <br>
1     | Community1 |  ACSNET    
1     | Community2 |  ACSNET    
1     | ValueNet   |  yes   
2     | Community3 |  ACSNET    
2     | Community4 |  ACSNET    
2     | ValueNet   |  no

my result table should be: 

col_1    | col_2    |   col_3 <br>
2     | Community3 |  ACSNET    
2     | Community4 |  ACSNET
sqlfiltergroup-bypostgresql-12


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions