Hi I have table with three columns, i want to show only true condition if there is true and false condition for same ID
if there is one condition for ID, it come as it is like below output
| ID |
names |
condition |
| 1 |
abc;aba;bca |
yes |
| 1 |
abc;aba;bca |
No |
| 2 |
fff;lll;mmm |
yes |
| 2 |
fff;lll;mmm |
No |
| 3 |
qqq;www;rrr |
No |
| 3 |
qqq;www;rrr |
yes |
| 4 |
kkk;ooo |
NO |
| 5 |
ggg;aaa;zzz |
NO |
Output
| ID |
condition |
|
| 1 |
yes |
|
| 2 |
yes |
|
| 3 |
yes |
|
| 4 |
NO |
|
| 5 |
NO |
|
