select count(*) from xx; -- 100
select count(*) from xx where field in ('01','02','03','04') ; --95
select count(*) from xx where field not in ('01','02','03','04') ;一定是5?
当字段为null时,not in不会统计该行,只有field全部不为空时,in和not in数据查询才会一致
select count(*) from xx; -- 100
select count(*) from xx where field in ('01','02','03','04') ; --95
select count(*) from xx where field not in ('01','02','03','04') ;一定是5?
当字段为null时,not in不会统计该行,只有field全部不为空时,in和not in数据查询才会一致