table42.sql

Oracle 9i中文版基础培训教程

select *  from scott.emp where job='MANAGER' and sal<>2000;

select *  from scott.emp where job!='MANAGER' or sal<>2000;

select *  from scott.emp where not job>='MANAGER';