sql - Select a row from the group of row on a particular column value -

i want write query achieve following. have table xyz in there multiple row same column value(1) in column a.

i want find in column b doesn't have particular value set of rows value 1 in column a.

table xyz ---------   b    1  te  1   1  re  2  te  2  re  3  ge  4  re

so want find if column b not have value 'te' set of values column a

when

select xyz b <> 'te' group

i 1,2,3 , 4 both result.

but want result should contain 1 , 2. please help.

select xyz (b<>'te') , ((a=1) or (a=2))

or variant

select xyz (b<>'te') , (a in (1, 2))

Live