select only true condition

[pala_jagadeesh]

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

[pala_jagadeesh]

@PrashantSangle ,

@Afa_Momin 

Thank you