filter condition

Hi Team ,

Currently I am  working on one requirement mentioned below :

I have 3 states 'A' , 'B','C'  and one num field containing those states multiple times

I have to filter data as num should have combination of above 3 states (A and B and C)

I have tried using if else due to multiple rows in which each num  having many A, B and C I am getting NULL.

Could any one please provide any solution.

let me know if you need more information regarding it.