How to Find values with Only No

Question

I have an dataset like this where A,B are one set and C,D,E are another set.

I want to Filter out data where all the entries are Yes.For e.g. Only C,D,E should be returned not B.

How do you define the sets. Do you just *know* what rows are part of a group? — Gordon Linoff, Jun 25 '18 at 12:02
What is the name of the table, what are the names and types of the columns? — Jodrell, Jun 25 '18 at 12:05

score 1 · Answer 1 · answered Jun 25 '18 at 12:04

1

If you want filter then you can use NOT EXISTS :

select t.*
from table t
where not exists (select 1 from table t1 where t1.id = t.id and t1.status = 'no');

answered Jun 25 '18 at 12:04

Yogesh Sharma

1 Answers1