Equality and inequality symbols in a WHERE clause

You can write a WHERE search condition using any of the symbols of equality or inequality in WHERE. For example, to select only employees who have made commissions of $1,000 or more:

This query:

SELECT ID, COMM
FROM Q.STAFF
WHERE COMM >= 1000

Produces this report:

  ID     COMM
----- -------
  70  1152.00
  90  1386.70
 340  1285.00

Additional examples:

• Select everyone with 10 years of service or more:

  SELECT ID, NAME, YEARS
  FROM Q.STAFF
  WHERE YEARS >= 10

• Select everyone with more than ten years of service:

  SELECT ID, NAME, YEARS
  FROM Q.STAFF
  WHERE YEARS > 10

• Select every manager:

  SELECT ID, NAME, YEARS
  FROM Q.STAFF
  WHERE JOB = 'MGR'

• Select everyone whose name occurs later in the alphabet than SMITH:

  SELECT NAME, ID
  FROM Q.STAFF
  WHERE NAME > 'SMITH'

• Select every employee name in Q.STAFF that is not in department 10:

  SELECT NAME, ID
  FROM Q.STAFF
  WHERE DEPT < > 10