经典面试题1:
试问:select * from employees;
和 select * from employees where commission_pct like '%%' and last_name like'%%’;
结果是否一样?并说明原因
答:结果不一样
select * from employees;
是从employees中查询所有的数据
select * from employees where commission_pct like '%%' and last_name like'%%’;
如果判断的字段有null值,则该语句出现问题。
如何改进呢?
select * from employees where commission_pct like '%%' or last_name like'%%’ or salary linke '%%' …………;
(后面是该表中所有的字段名)因为主段不能为null,保证了代码的正确性。