select count(*) from carve_e_reviewproject where (DELETED<>'1' or DELETED ='1');
结果:53
select count(*) from carve_e_reviewproject
结果:55
还有2条到哪里了,原来 DELETED<>'1' ,是不包括is null的情况的
select count(*) from carve_e_reviewproject where (DELETED<>'1' or DELETED ='1');
结果:53
select count(*) from carve_e_reviewproject
结果:55
还有2条到哪里了,原来 DELETED<>'1' ,是不包括is null的情况的