You seem want :
select t.*
from table t
where not exists (select 1 from table t1 where t1.group = t.group and t1.name="xxxx")
1
solved Multi not like expression sql
You seem want :
select t.*
from table t
where not exists (select 1 from table t1 where t1.group = t.group and t1.name="xxxx")
1
solved Multi not like expression sql