表全部数据: – department 字段为varchar类型,gender 为int类型 sql1:select * from employee where department != '水利厅'; 结果1: sql2:select * from employee where department <> '水利厅'; 结果2: sql3:select * from employee where gender !=2;
问题:sql的where条件中分别加 != 和 <>,看是否会筛选出字段值为空(Null)的记录。数据库类型:Mysql5.6、Oracle11Mysql:表全部数据:– department 字段为varchar类型,gender 为int类型sql1: select * from employee where department != ‘水利厅’;结果1:...