DB2 graphic  QMF Version 8

EXISTS

The EXISTS statement determines whether a row exists that satisfies a given condition, as shown in the subquery of the following query:

   SELECT ID, NAME, DEPT
   FROM Q.STAFF CORRVAR
   WHERE EXISTS
     (SELECT * FROM Q.ORG WHERE MANAGER = CORRVAR.ID)

See IN for other methods of conditionally selecting values.


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