ORACLE循序渐进讲解（第二讲）(三)

SQL> select ename,sal from emp where sal>2500
  2    minus
  3    select ename,sal from emp where job='MANAGER'
  4  ;
ENAME            SAL
---------- ---------
FORD         3000.00
KING         5000.00
SCOTT        3000.00