DB2 graphic  QMF Version 8

OR -- Present on either of two conditions

Two conditions connected by OR allow the query to select every row that satisfies one or the other of the conditions. The following query selects rows where either the YEARS column is equal to 10 or the SALARY column is greater than 20000.

When you run this query:

Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM |
--------+----+------+------+-----+-------+--------+------|
        | P. | P.   |      |     | P. _Y | P. _S  |      |
 
|        CONDITIONS           |
|-----------------------------|
| _Y = 10 OR _S > 20000       |

QMF produces this report:

   ID  NAME       YEARS     SALARY
-----  ---------  -----  ---------
   50  HANES         10   20659.80
  140  FRAYE          6   21150.00
  160  MOLINARE       7   22959.20
  210  LU            10   20010.00
  260  JONES         12   21234.00
  290  QUILL         10   19818.00
  310  GRAHAM        13   21000.00


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