DB2 graphic  QMF Version 8

Nesting column functions within scalar functions

Suppose that you want to know the year in which the last project in department 20 will be initiated. If you run this query:

SELECT YEAR(MAX(STARTD))
  FROM Q.PROJECT
  WHERE DEPT = 20

QMF produces this report:

    LAST
   PROJECT
    START
----------
      1997


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