Filter/Select multiple rows

Is this possible to do?

The result I want is to filter ALL common (group of) values column CA that has the value 1 in column CB

CA	CB
----------
A	0
A	0
A	1
A	0
B	1
C	0
C	0
C	0
D	0
D	0
D	1
E	1
E	1
F	0
F	0
F	0
F	0

So the result would look something like this:

CA	CB
----------
C	0
C	0
C	0
F	0
F	0
F	0
F	0