table42.sql

来自「本书是Oracle 9i的基础培训教程,适用于Oracle初学者和有基本了解的人」· SQL 代码 · 共 7 行

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';