DB2 graphic  QMF Version 8

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:


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004