NOT with NULL, LIKE, IN, and BETWEEN

You can use NOT NULL, NOT LIKE, NOT IN, or NOT BETWEEN. For example:

WHERE YEARS IS NOT NULL

It is only in these cases that NOT can follow the entire condition.

Examples:

• Select everyone whose salary is NOT between $17,000 and $21,000:

  SELECT ID, NAME, SALARY
  FROM Q.STAFF
  WHERE SALARY NOT BETWEEN 17000 AND 21000

• Select everyone who does NOT earn a salary less than $18,000 and also earns a commission of less than $500:

  SELECT ID, NAME, SALARY, COMM
  FROM Q.STAFF
  WHERE NOT (SALARY < 18000 AND COMM < 500)

• Select only managers in Q.STAFF who are NOT managers of departments in the Q.ORG table:

  SELECT ID, NAME, DEPT
  FROM Q.STAFF
  WHERE JOB = 'MGR'
  AND ID NOT IN (SELECT MANAGER FROM Q.ORG)