经典面试题
试问: select * from employees 和
select * from employees where comission_pct like '%%' and last_name like '%%';
结果是否一样?并说明原因
答:不一样! 如果判断的字段有null值
变化: select * from employees where comission_pct like '%%' or last_name like '%%';
答:一样,因为是or
02-19
4万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)