DB2 graphic  QMF Version 8

AND

You can select rows based on multiple conditions connected by AND or OR. Two conditions connected by AND select only rows that satisfy both conditions. For example:

This query:

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

Produces this report:

   ID  NAME       YEARS     SALARY
-----  ---------  -----  ---------
   50  HANES         10   20659.80
  210  LU            10   20010.00

Compare the results using AND with OR.


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