1.not in:
select * from table where (field1,field2,field3) not in (select field1,field2,field3 from table)
注意 其中字段有🈳️值的情况会导致查不到结果集,数据量大会导致查询缓慢
2.not exists :
select * from table t1 where not exists (select field1,field2,field3 from table t2 and t1.field1=t2.field1 and t1.field2=t2.field2 and t1.field3=t2.field3 )