DB2 graphic  QMF Version 8

AND -- Present on two conditions

Two conditions connected by AND cause the query to select only rows that satisfy both conditions. The query below selects rows where the YEARS column is equal to 10, and the SALARY column is greater than 20000. The query selects only the two rows that satisfy both of these conditions.

When you run this query:

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

QMF produces this report:

   ID  NAME       YEARS     SALARY
-----  ---------  -----  ---------
   50  HANES         10   20659.80
  210  LU            10   20010.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