Suppose I have 3 columns, Item, SubItem, Number.
I want to select the rows only when all the subitems have number as 0.
For example in the below table, only Phone and Pant should be selected since all their subitems have number=0.
Also duplicate rows should not be returned. Only one row of each item should be returned.