Except: 
(
SELECT  DEPT.DEPTNO,  DEPT.DNAME,  DEPT.LOC,  EMP.ENAME
FROM  DEPT,  EMP
WHERE   ( EMP.DEPTNO=DEPT.DEPTNO  )
MINUS  
SELECT  DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO  )
  AND EMP.ENAME  =  'JONES')

Both:
(
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO  )
  AND EMP.ENAME  =  'ADAMS'
INTERSECT  
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM  DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO  )
  AND EMP.ENAME  =  'ALLEN'
)

Match Pattern: LIKE “ABC%”
DFFERENT PATTERN: NOT LIKE “ABC%”