不等于符号会把code为null的记录过滤掉
SELECT * FROM person WHERE sex='女' and code != 'xxx';
Oracle:
解决方法:NVL函数
SELECT * FROM person WHERE sex='女' and (code != 'xxx' or code is null);
或
SELECT * FROM person WHERE sex='女' and NVL(code,0) != 'xxx';
MySQL:
解决方法: IFNULL函数
SELECT * FROM person WHERE sex='女' and IFNULL(code,0) != 'xxx';