【文件属性】:
文件名称:使用NOT运算符-oracle基础讲义
文件大小:4.17MB
文件格式:PPT
更新时间:2021-04-22 13:29:17
orcle基础讲义
使用NOT运算符
SELECT last_name, job_id
FROM employees
WHERE job_id
NOT IN ('IT_PROG', 'ST_CLERK', 'SA_REP');
NOT 运算符也可以和其他SQL运算符一起使用
... WHERE job_id NOT IN ('AC_ACCOUNT', 'AD_VP')
... WHERE salary NOT BETWEEN 10000 AND 15000
... WHERE last_name NOT LIKE '%A%'
... WHERE commission_pct IS NOT NULL
*