DB2 graphic  QMF Version 8

Nesting scalar functions within column functions

If a column function's argument is a scalar function, the scalar function must include a reference to a column. For example, if you want to know the last year that any project will begin and the last year that any project will complete, you can run this query:

SELECT MAX(YEAR(STARTD)), MAX(YEAR(ENDD))
  FROM Q.PROJECT

QMF produces this report:

    LATEST        LATEST
     START      COMPLETION
  -----------  -----------
         1999         2000


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