SQL 多列查询 not in, not exists 写法

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 )