5Null值的处理逻辑操作.pptVIP

Null值的处理、逻辑操作 什么是空值null 例5-1 SQL select last_name,job_id,salary,commission_pct from employees where job_id in (‘PU_CLERK’,’ PU_MAN’) order by job_id; 含有空值的表达式的运算 例5-2 SQL select last_name “Name”, salary+commission_pct,job_id from employees where job_id not like ‘SA%’ order by job_id; 例5-3 SQL select employee_id, last_name Name, salary,commission_pct,job_id 2 from employees 3 where commission_pct=NULL; 例5-4 SQL select employee_id, last_name Name, salary,commission_pct,job_id 2 from employees 3 where commission_pct !=NULL; 例5-5 SQL select employee_id, last_name Name, salary,commission_pct,job_id 2 from employees 3 where commission_pct is NULL; 例5-6 SQL select employee_id, last_name Name, salary,commission_pct,job_id 2 from employees 3 where commission_pct is not NULL; 空值的排序 例5-7 SQL select last_name , commission_pct, job_id 2 from employees 3 Order by commission_pct; 例5-8 SQL select last_name , commission_pct, job_id 2 from employees 3 Order by commission_pct desc; 逻辑表达式和逻辑运算符 AND OR NOT oracle引入null AND的真值表 AND运算的优先级 F ____ NULL ____ T 例5-9 SQL select employee_id, last_name , job_id 2 from employees 3 where salary=8000 4 and job_id in (‘SA_MAN ’,’ST_CLERK ’,’ST_MAN’) 5 Order by job_id; OR的真值表 or运算的优先级 T ____ NULL ____ F 例5-10 SQL select employee_id, last_name , job_id 2 from employees 3 where salary=8000 4 or job_id in (‘SA_MAN ’,’ST_CLERK ’,’ST_MAN’) 5 Order by job_id; not的真值表 not运算的优先级 T ____ NULL ____ F 运算符的优先级别 算数运算符 连接运算符 比较（关系）运算符 Is null,is not null,like,not like,in,not in运算符 Between,not between运算符 Not 逻辑运算符 And 逻辑运算符 Or 逻辑运算符 例5-11 SQL select employee_id, last_name ,salary,job_id 2 from employees 3 where job_id =‘SA_MAN ’ 4 or job_id =‘ST_CLERK ’ 5 and salary=13000; 例5-12 SQL select employee_id, last_name ,salary,job_id 2 from employees 3 where (job_id =‘SA_MAN ’ 4 or job_id =‘ST_CLERK ’) 5 and salary=13000; 用and和or代替between and和in运算符 例5-13 SQL SELECT employee_id，last